Hi all
I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted.
<tbody>
</tbody>
I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted.
Time-in | Time-out | Time-in | Time-out | Time-in | Time-out |
08:00 | 18:00 | 09:00 | 22:00 | 06:00 | 17:00 |
12:00 | 23:00 | 07:00 | 16:00 | 10:00 | 19:00 |
<tbody>
</tbody>