I have an excel column (imported from another tool) with times in the following Days:Hours:Minutes
However the Days are not displayed if 0
13:10
1:02:07
1:14:08
01:00
2:03:28
1:07:10
2:05:36
1:16:56
02:00
00:00
3:01:01
1:08:00
00:20
02:42
00:00
1:19:39
My end goal is to convert to Hours:Minutes so I can used the (Time Formula) Hour Formula, Minute Formula, Second Formula (Not Relevant)
Not sure where to go from here?
Any help greatly appreciated
Bookmarks