How do I add time, in the hr:mn format, and view total time in the same hr:mn
format when the total time is greater than 23:55?

Hi!

Format the total cell as [h]:mm.

The [ ] keeps the hours from rolling over back to zero after 24 hours is
reached.

Biff

"simon, uk" <simon, wrote in message
...
How do I add time, in the hr:mn format, and view total time in the same
hr:mn
format when the total time is greater than 23:55?

Just add them up like this

=A1+B1

and use a custom format like this

[h]:mm

"simon, uk" wrote:

How do I add time, in the hr:mn format, and view total time in the same hr:mn
format when the total time is greater than 23:55?

Thanks guys - works a treat.

"Sloth" wrote:

Just add them up like this

=A1+B1

and use a custom format like this

[h]:mm

"simon, uk" wrote:

How do I add time, in the hr:mn format, and view total time in the same hr:mn
format when the total time is greater than 23:55?