Hello,
I have a column of time duration (in general formatting) like below that I need to split into three columns for hour, minutes and seconds to be able to filter/work with numbers. Not every cell has all three "fields" however, so I would need the numbers to land in the right column. Is there a formula that can help do this?
what I have:
2h 48m 15s
28m
11m 31s
2h 15m 21s
7h 1m 29s
13m 10s
16m 39s
42s
What I need:
Hours Minutes Seconds
2 48 15
28
11 31
2 15 21
7 1 29
13 10
16 39
42
Thank you!
Bookmarks