Lovelylou79
New Member
- Joined
- Sep 4, 2017
- Messages
- 37
Hi there,
I am looking for some help regarding identifying differences between a recorded amount of hours and the recorded duration (Start/end Time).
In the following table Duration is calculated using "=B2-A2+(A2>L2).
Row 1 would not need highlighting as duration is less than 60 minutes over the hours, Row 2 would need to be highlighted as hours are less than duration, Row 3 hours and duration match so no highlight is needed, and Row 4 hours are higher than the duration.
I would prefer this in vba as it is part of a larger function. Thank you!!
<tbody>
</tbody>
I am looking for some help regarding identifying differences between a recorded amount of hours and the recorded duration (Start/end Time).
In the following table Duration is calculated using "=B2-A2+(A2>L2).
Row 1 would not need highlighting as duration is less than 60 minutes over the hours, Row 2 would need to be highlighted as hours are less than duration, Row 3 hours and duration match so no highlight is needed, and Row 4 hours are higher than the duration.
I would prefer this in vba as it is part of a larger function. Thank you!!
Hours | Start Time | End Time | Duration |
3 | 07:45 | 11:30 | 03:45 |
3 | 12:30 | 17:30 | 05:00 |
3 | 13:00 | 16:00 | 03:00 |
3 | 16:00 | 17:30 | 01:30 |
<tbody>
</tbody>