Question Locked
How can you calculate total time for multiple h:mmm cells using Excel?
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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