98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Adding up time greater than 24 hours

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

Added by Martin on 18th September 2006

More Excel hints and tips, like:

• Use the Ctrl-key for quick navigation in Excel 2010
• Removing custom dictionary entries
• Selecting constant values only