Adding time

[simon, uk]

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?

[Biff]

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, [email protected]> wrote in message
news:[email protected]...
> 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?

[Sloth]

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?

[simon, uk]

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?