Need assistance to troubleshoot calculating beetween times in columns a1 and b1.
First 3 hours 50
succeeding 10 thereafter (after 3 hours)
and 200 for every 24 hours period
Thank you
First 3 hours 50
succeeding 10 thereafter (after 3 hours)
and 200 for every 24 hours period
Thank you
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | TIME IN | TIME OUT | DURATION HOURS | CHARGE | ||
2 | 13:54 | 22:54 | 9:00 | 51.625 | ||
3 | 14:54 | 23:54 | 9:00 | 51.625 | ||
4 | 15:54 | 0:54 | 9:00 | 51.625 | ||
5 | 16:54 | 1:54 | 9:00 | 51.625 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2:C5 | C2 | =B2-A2 |
D2:D5 | D2 | =IF(C2<=TIME(3,0,0)*50,50+(C2+TIME(3,0,0)*10)) |