Hi, I have a column with the duration of a number of courses written in hours and minutes, and minutes and seconds as in the example below.
Below the column starts with 4 hours and 35 minutes. And in the last cell you have 58 minutes and 36 seconds.
Is there a way that I can add the values as they are, in order to get the total duration as a time value (in hours, minutes and seconds), without having to remove the letters?
Your help will be much appreciated.
Thanks in advance.
4h 35m
3h 9m
6h 16m
8h 46m
58m 36s
Bookmarks