How can you calculate total time for multiple h:mmm cells using Excel? - TechRepublic
Question
October 29, 2009 at 08:09 AM
rlesnikowski

How can you calculate total time for multiple h:mmm cells using Excel?

by rlesnikowski . Updated 16 years, 8 months ago

A process is being timed and I need to calculate the total. I have the elapsed time cells formatted with h:mmm.
SUM works fine until you exceed 24 hours.

Example:
4 hrs 30 mins
2 hrs 26 mins
3 hrs 17 mins
Total – 10 hrs 13 mins

This discussion is locked

All Comments