Hi,
I have a set of numbers which appears to represent elapsed time in the "mm:ss.0000" format which may or may not be an Excel time format.
Here are a few examples of the numbers with their corresponding time value in square brackets:
6.098 [6.098]
9.377 [9.377]
90.557 [1:30.5574]
92.958 [1:32.9577]
899.803 [14:59.8033]
905.082 [15:05.0820]
I need a formula to convert this set of time codes into either their original format or simply the mm:ss time format, so that 905.082 becomes 15:05.0820 or simply 15:05, while 6.098 remains the same or converts to 00:06
Any ideas?
Thanks!
Bookmarks