Help Needed Urgently

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>