Harold Garcia
Board Regular
- Joined
- Jan 2, 2014
- Messages
- 72
how can i conditional formatting the time in/time out having a graveyard shift (9:45pm to 5:45am)
and how can i compute the total hours an employee work in graveyard shift only (9:45pm to 5:45am), exceeding hours will not be taken out.
heres the sample data
<tbody>
</tbody>
and how can i compute the total hours an employee work in graveyard shift only (9:45pm to 5:45am), exceeding hours will not be taken out.
heres the sample data
Name | Time IN | Time Out | Time IN | Time Out | Time IN | Time Out |
Dela Cruz, Juan | 8:45pm | 5:50am | 10:30pm | 5:56am | 8:49pm | 6:01am |
Smith, John | 1:10pm | 10:01pm | 1:45pm | 10:00pm | 1:20pm | 9:58pm |
Maloles, Helen | 9:30pm | 6:01am | 8:49pm | 5:50am | 8:45pm | 6:01am |
Garcia, Patrick | 1:30pm | 10:00pm | 2:30pm | 10:00pm | 1:14pm | 9:55pm |
<tbody>
</tbody>