Number
Hey guys, So in this scenario if there's no hours worked how do I keep the cell "Blank"? because there's a zero, my total hours formula isn't working.
Would love to get some help on this.
Thanks in advance.
ta
MacBook Pro 13″, macOS 10.14
Question marked as
You can do something like this:
In D2, filled down:
=IF(OR(ISBLANK(B2),ISBLANK(C2)),DURATION(0), C2−B2)
You can see a working example of this approach in column E of the 'Sign In ' table of the 'Employee Schedule' template at File > New in your menu.
Use ; instead of , in the formula if your regions uses , as the decimal formula.
SG