I'm still an excel beginner and I can't seem to get a formula on how to convert unusual time format to just hh:mm:ss
Here are some examples:
0d:0h:4m:48 s:
0d:0h:3m:39 s:
0d:0h:8m:37 s:
0d:0h:31m:57 s:
0d:0h:4m:9 s:
I would like to have it converted to just MM:SS
4:48
3:39
8:37
31:57
4:09
Bookmarks