tel 01732 833085 · e-mail david wallis
AT, Wisconsin (2010)
We 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?
The formula you created with AutoSum is fine.
All you need do is apply an appropriate format to its result:
DMW Consultancy Ltd does not accept any liability for loss or damage to data to which any techniques, methods or code included in this website are applied. Back up your data; test thoroughly before using on live data.