Yeah, that's what I do, but it doesn't entirely work. I set up the cell with that formatting, and then type in "0:52.41" and hit enter. I click on the cell again in the the box right below the toolbars (where you input formulas) it says "12:00:52 AM". WTF?!?
The value is correct but the formatting is wrong. Follow Ahmed's instructions: go to "format cells" (Ctrl+1 is the shortcut key), then go to the "Number" tab and the "Custom" category (where it is may depend slightly on your Excel version). Type in "m:ss.00" in the "Type" box. Ahmed's instructions are probably more clear than this.
Excel stores all times and dates as serial numbers (basically, days as a decimal number). Changing the formatting doesn't change the value of the serial number, only how it is displayed. What you are seeing is the number you input in the "time" format, or "h:mm:ss AM/PM". You just need to change the type of formatting to "m:ss.00", it is still the same number either way (0.000606597222222222 to be exact!).
Yeah, that's what I do, but it doesn't entirely work. I set up the cell with that formatting, and then type in "0:52.41" and hit enter. I click on the cell again in the the box right below the toolbars (where you input formulas) it says "12:00:52 AM". WTF?!?
The value is correct but the formatting is wrong. Follow Ahmed's instructions: go to "format cells" (Ctrl+1 is the shortcut key), then go to the "Number" tab and the "Custom" category (where it is may depend slightly on your Excel version). Type in "m:ss.00" in the "Type" box. Ahmed's instructions are probably more clear than this.
Excel stores all times and dates as serial numbers (basically, days as a decimal number). Changing the formatting doesn't change the value of the serial number, only how it is displayed. What you are seeing is the number you input in the "time" format, or "h:mm:ss AM/PM". You just need to change the type of formatting to "m:ss.00", it is still the same number either way (0.000606597222222222 to be exact!).
