Totalling Hours & Minutes

  • Thread starter Thread starter Bob Richerby
  • Start date Start date
B

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
 
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
 
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)


Bob Richerby said:
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

Norman Harker said:
Hi Bob!

Format [hh]:mm

the [ and ] prevent roll over after 60 minutes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Click to expand...
Click to expand...
 
Back
Top