Tuesday, March 20, 2012

Adding Excel Times Greater Than 24 Hours/Showing Excel Times Past 24 Hours

To force Excel not to default back to a new day after 24 hours we use a cell Format of 37:30:55 or a Custom format of [h]:mm:ss

http://www.ozgrid.com/Excel/times-past-24.htm

No comments:

Post a Comment