S
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?
format when the total time is greater than 23:55?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
Format the total cell as [h]:mm.
The [ ] keeps the hours from rolling over back to zero after 24 hours is
reached.
Biff
S
Sloth
Just add them up like this
=A1+B1
and use a custom format like this
[h]:mm
=A1+B1
and use a custom format like this
[h]:mm
S
simon, uk
Thanks guys - works a treat.
Sloth said:Just add them up like this
=A1+B1
and use a custom format like this
[h]:mm
simon said: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?