Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
FAC-Visits-6.11-6.17.21-Hours.xlsx | ||||||
---|---|---|---|---|---|---|
F | G | H | I | |||
7 | 12:49:00 | 6/16/21 | 14:29:00 | 1:40:00 | ||
8 | 13:57:00 | 6/15/21 | 19:09:00 | 5:12:00 | ||
9 | 12:32:00 | 6/14/21 | 19:23:00 | 6:51:00 | ||
10 | 15:08:00 | 6/13/21 | 19:50:00 | 4:42:00 | ||
11 | 12:22:00 | 6/12/21 | 23:16:00 | 10:54:00 | ||
12 | 15:58:00 | 6/12/21 | 3:58:00 | 564:00:00 | ||
CareWatch |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I7:I12 | I7 | =IF(ISBLANK(F7),"No Check out",IF(H7<F7,(H7+24)-F7,H7-F7)) |