My previous suggestion in your other post works. Keep to that thread, I have
responded.

--
HTH

Bob Phillips

"John" wrote in message
...
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