ExcelBanter - how to add a column of time values eg 72hours plus 34hours 52mins

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to add a column of time values eg 72hours plus 34hours 52mins (https://www.excelbanter.com/excel-discussion-misc-queries/107594-how-add-column-time-values-eg-72hours-plus-34hours-52mins.html)

David R

how to add a column of time values eg 72hours plus 34hours 52mins

In excel I am trying to sum a column of time values
eg
5hours 3mins
6hours 35mins
76hours 58mins
How can I do this in Excel, please help!

Toppers

how to add a column of time values eg 72hours plus 34hours 52mins

If the times are formatted as hh:mm ( or [hh]:mm if hours 24), then use SUM
function with cell formatted as [hh]:mm.

"David R" wrote:

In excel I am trying to sum a column of time values
eg
5hours 3mins
6hours 35mins
76hours 58mins
How can I do this in Excel, please help!

All times are GMT +1. The time now is 02:59 AM.