J
John
I am woking on a spreadsheet and i need a running total on the hours worked
for by staff.
This is the way inwitch the data is set out.
08:30-21:00
08:30-17:30
11:00-19:00
10:00-18:00
14:00-18:00
19:00-24:00
11:00-19:00
09:30-17:30
10:30-18:30
08:30-17:00
I have tried a sum but it does'nt return the correct total
is there any one that could help us with this
Thanks
for by staff.
This is the way inwitch the data is set out.
08:30-21:00
08:30-17:30
11:00-19:00
10:00-18:00
14:00-18:00
19:00-24:00
11:00-19:00
09:30-17:30
10:30-18:30
08:30-17:00
I have tried a sum but it does'nt return the correct total
is there any one that could help us with this
Thanks