Keeping it short and sweet:
We have a Col A (Age) and want the ouput converted to time as shown in Col B so we can sort it.
Age, Output (mm:dd:hh:mm)
3d 3h, 00:03:03:00
16h 3m, 00:00:16:03
14h 6m, 00:00:14:06
1d 20h
7d 13h
12h 36m
8h 48m
1mo 7d
16h 52m
3d 13h
2mo 1d
12h 53m
21h 55m
5d 13h
5d 19h
20h 54m
17h 30m
21h 22m
19h 49m
4d 12h
How do we do it with a formula?
Bookmarks