How to add hours and minutes (not time) in a single cell?

**Sindhiiu** · 09-05-2012, 11:18 AM

Dear Friends, hi.

My first time to this forum.

How can I sum up several hours and minutes in a single cell? For Example =sum(2:10+3:45+4:25+5:15+......). Notice these are just working hours and
not time (am/pm). Please help.

Regards

**daddylonglegs** · 09-05-2012, 11:25 AM

Are the time values in cells or do you want to put them directly in the formula?

For the former try just summing, e.g.

=SUM(A1:A5) or = SUM(A1,A3,A5)

if you want to enter times in the formula you can use this method

="2:10"+"3:45"+"4:25"+"5:15"

either way format result cell as custom [h]:mm