minutes - yyyy mm dd hh mm ss milliseconds in excel
Converting MM:SS.ms to seconds using MS excel (2)
0:1:11.111 in cells
Now format it to account for the milliseconds... Select cells
B4, right click and choose Format Cells. In Custom, put the following in the text box labeled
Now on cell
C3 put the following formula:
C4 with the same formula...
Number with 3 decimal places.
You're done! :)
Here's a screenshot of the attempt I made and that worked:
As you wanna enter only
MM:SS.ms you can format the entire
B column with a custom format like:
mm:ss.000. Now you can enter values as
02:11.111 and it'll convert it accordingly giving you
131.110. Hope it helps.
I am looking for a neat way of converting a cell from
11.111 = 11.111 1:11.111 = 71.111
I have something in place at the moment but its a bit hacky and I am sure there must be some nice excel feature to do this for me :P
say your time is in cell
A1, place this formula in
If the time is less than a minute it outputs the time unaltered, greater than 1 minute it converts it to seconds & milliseconds (2 decimal places).
This will only work if your time in
A1 is 10 seconds or greater.