Hi,
I have created an hours time table calculating the shifts patterns of our workers and it looks similar to this:
Start time Finish time Deduct Lunch Total hours Day off (Y/N) Week 1 Monday 0:30 Tuesday 0:30 Wednesday 0:30 Thursday 0:30 Friday 0:30 Saturday 0:30 Sunday 0:30 Total hours 0.00I am looking to complete a total number of hours worked after 6pm and then another cell with total number of hours worked prior to 6pm.
Example:
Start time: 09:00
Finish time: 21:00
Total hours: 11.5
Hours pre 6pm: 8.5
Hour after 6pm: 3
How do i create to cells that automatically calculate hours pre and post 6pm (i.e in the above example calculate 8.5 and 3) ?
Many thanks.