I have a column of trip times that were calculated utilizing military time and the custom format of [h]:mm. Doing this results in trip times that calculate out perfectly. What I am not able to do, is total these trip times! How should my function read, and what formatting do I need to sum these trip time totals?
Ie. Trip Times Totals in Column:
6:00 (6 hours)
4:15 (4 hours, 15 minutes)
2:30 (2 hours, 30 minutes)
Should = 12 hours 45 minutes... instead, the total still reads 0
What am I doing wrong?
Bookmarks