I have now got the times running correctly but on another part of my
spread sheet I ask it to total up the columns
=SUM(H7:H15) and the total should show as 57:00 but is only giving me
09:00 cannot work out why it is doing this, as I have set up as hh:mm
on all the columns.

Helen

Helen Black Wrote:
Hi Julie

Thanks for this, it does show as you said so I will now try to correct
my spread sheet hope this sorts it now it is doing my head in. all
because drivers have new regulations coming in what about us office lot
that sit at home on a night until the early hours doing stuff like
this.

Helen


--
Helen Black

Hi Helen

you could try the following formula
=SUM(H7:H15)*24
and format as a number

Let me know if this works better
Cheers
JulieD

"Helen Black" wrote in
message ...

I have now got the times running correctly but on another part of my
spread sheet I ask it to total up the columns
=SUM(H7:H15) and the total should show as 57:00 but is only giving me
09:00 cannot work out why it is doing this, as I have set up as hh:mm
on all the columns.

Helen

Helen Black Wrote:
Hi Julie

Thanks for this, it does show as you said so I will now try to correct
my spread sheet hope this sorts it now it is doing my head in. all
because drivers have new regulations coming in what about us office lot
that sit at home on a night until the early hours doing stuff like
this.

Helen


--
Helen Black