Totalling Hours & Minutes

[Bob Richerby]

I need to be able to total hours and minutes eg 12345:45 (12345hrs & 45mins)
+ 1:45. The current format option only allows hh:mm

Thanks

Bob R

 

[Norman Harker]

Hi Bob!

Format [hh]:mm

the [ and ] prevent roll over after 60 minutes.

 

[Bob Richerby]

This method only appears to work with numbers up to 9999. Any number above
this seems to be formated as text. Also, if the number of hours is above 99,
then it is converted to a date and hours. I need to be able to add up data
such as 12345:45 + 2:45 = 12348:30.

Regards

BobR

 

[Peo Sjoblom]

There are probably better suited programs than Excel if you want to do
payroll,
you can however enter it as

=12345/24 + "0:45" + "2:45"


format as [hh]:mm

so with every value that is over 9999:59:59 you need to divide the hours
with 24 then add the rest as the above

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

This method only appears to work with numbers up to 9999. Any number above
this seems to be formated as text. Also, if the number of hours is above 99,
then it is converted to a date and hours. I need to be able to add up data
such as 12345:45 + 2:45 = 12348:30.

Regards

BobR

Hi Bob!

Format [hh]:mm

the [ and ] prevent roll over after 60 minutes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)