add time greater than 9999:56

cells are formatted to [h]:mm and will not use a number higher than 9999:56

Hi!

You can manually enter time values up to 9999:59, above that they are
automatically evaluated as GENERAL TEXT values.

You can calculate time values well in excess of 9999:59

A1 = 9999:59
A2 = 9999:59

=SUM(A1:A2)

Returns 19999:58

Biff

"PapaT" <[email protected]> wrote in message
news:[email protected]...
> cells are formatted to [h]:mm and will not use a number higher than
> 9999:56

Use this technique, assume you have 35523 hours and you want to add 11450
hours to that, use

=(35523/24)+(11450/24)

or if you have the times in cells A2:A3

=SUM(A2:A3)/24

returns 46973:00:00 formatted as [hh]:mm:ss

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"PapaT" <[email protected]> wrote in message
news:[email protected]...
> cells are formatted to [h]:mm and will not use a number higher than
> 9999:56