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
Top-ranking reply
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