home > technical tips > excel tip

excel - summing time values

question

I have a column of cells in an Excel spreadsheet containing times like, 3:15, relating to the time spent on a task. At the bottom of the column I've used AutoSum to add up the times, but the result appears as either a date or funny number. What do I do to get a total in hours and minutes?

answer

The formula you created with AutoSum is fine.

All you need do is apply an appropriate format to its result:

disclaimer

DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any of our Technical Tips solutions are applied. Back up your data; test thoroughly before using on live data.

home database design spreadsheets website design office templates office integration IT consultancy technical tips
about dmw site map