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

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

Hi John

See the answers you have to your original posting "Adding time values up in
Excel"
It is best to continue posting under the same thread as opposed to starting
a new one
Regards

Roger Govier


John wrote:
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