If you have a column of cells in an Excel spreadsheet containing times like, 8:15, relating to the time spent on something. At the bottom of the column you have used AutoSum to add up the times, but the result appears as either a date or funny number. What can you do to get a total in hours and minutes?
All you need do is apply an appropriate format to its result:
- Select the cell containing the total
- From the Format menu, choose the Cells command
- From the Category list, select Custom
- In the Type box, input the format [h]:mm
(note the use of square brackets).
If you want to show seconds in your total, input
[h]:mm:ss
(this format is listed in Excel's Custom formats) - Click OK
That’s it. Hope it helps!
7d873165-8b51-4811-a8b2-f52ba8ff548e|0|.0
General