Re: [OT] Excel Time Calculations

["Steve Cooper" <steve.cooper@xxxxxxx>]

Don you need to format the contents of the cell using a custom format of
[h]:mm.  The square brackets stop it rolling 24 hour over to a day.

Regards

Steve


=
=
=20
"Don                                                   =
=
=20
McAllister"          To:     <ukha_d@xxxxxxx>  =
=
=20
<donmc@cablei        cc:                               =
=
=20
net.co.uk>           Subject:     [ukha_d] [OT] Excel T=
ime Calculations                                       =
=20
=
=
=20
28/10/01                                               =
=
=20
22:25                                                  =
=
=20
Please                                                 =
=
=20
respond to                                             =
=
=20
ukha_d                                                 =
=
=20
=
=
=20
=
=
=20






OK Guys and Gals, I hope you don't mind if I slip in a quick OT request !



Basically, I want to create an excel spreadsheet that calculates Hours and
minutes worked in the week. No problem sorting out the daily hours and
minutes worked but I want to create a weekly total of hours and minutes.
When I sum the weeks daily times I can only produce an entry like:



01:10:30



whenI really want



34:30



i.e. it won't display more than 24 hours without flipping into days. I know
you can multiply the time by 24 but this gives 34.5 not 34:30



Any clues ?



TIA



Don


=
=20