G Guest Mar 2, 2006 #1 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?
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?
B Biff Mar 2, 2006 #2 Hi! Format the total cell as [h]:mm. The [ ] keeps the hours from rolling over back to zero after 24 hours is reached. 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
G Guest Mar 3, 2006 #4 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? Click to expand... Click to expand...
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? Click to expand... Click to expand...
