Laura Roberts
New Member
- Joined
- Jan 23, 2018
- Messages
- 4
in | 8:00 | 8:00 | ||
out | 12:30 | 12:15 | ||
in | 13:30 | 13:15 | ||
out | 17:30 | |||
total | 8:30 | 6:37 | 15:37 | 15:37 |
<tbody>
</tbody>
(now()=15:37)
Why is the first section (for all blanks being true) not parsing as 0?
in | 8:00 | 8:00 | ||
out | 12:30 | 12:15 | ||
in | 13:30 | 13:15 | ||
out | 17:30 | |||
total | 8:30 | 6:37 | 15:37 | 15:37 |
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
6 | in | 8:00 | 8:00 | ||||
7 | out | 12:30 | 12:15 | ||||
8 | in | 13:30 | 13:15 | ||||
9 | out | 17:30 | |||||
10 | total | 8:30 | 5:10 | 0 | 0 | ||
Sheet5 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B10 | {=IF(ISBLANK(B6:B9),"0",IF(ISBLANK(B7:B9),NOW()-B6,IF(ISBLANK(B8:B9),B7-B6,IF(ISBLANK(B9),(NOW()-B8)+(B7-B6),(B9-B8)+(B7-B6)))))} | |
Press CTRL+SHIFT+ENTER to enter array formulas. |