Go to (i.e., highlight) the Cells you want to format. Click on Format.........Cells..........
Choose "Custom" then find one that looks like mm:ss.0
In the input type box add another zero to it
mm:ss.00
and it works. I'm doing this with Excel 2000 (your version might be a bit different but these are the steps.)
Good Luck
Yep, this is what I do. I would add a few comments:
-- My own personal preference is to use the "m:ss.00" format for times greater than 60 seconds and "ss.00" for times under one minute.
-- If you input a number in this format (eg as "1:43.89"), Excel will automatically understand that you mean a time. But it won't give you enough decimal places, so change the format as described by Ahmed to display the hundreds. You can do this for an entire column of empty cells (click on the top heading of the column to select all of them before applying Custom Formatting) then you don't have to keep changing the format.
-- Say you do a time of 32.11 in a 50 free. If you input "32.11" in a cell that is formatted to display "m:ss.00," you will get "38.24.00" displayed. WTF? Excel assumed that you meant "32.11 days" and not seconds and then dutifully displayed it as m:ss.00 (with rollover, 0.11 days is 2 hours, 38 minutes and 24 seconds past midnight). So be sure to include the zeros: input it as "0:32.11."
-- You might find it convenient to record a macro and then assign it to an icon and/or shortcut key. Start the macro recording, change the format as Ahmed described to your liking, and then stop recording. At some point Excel should prompt you for a shortcut key and a macro name. Remember the name: you can assign it to a button on your toolbar -- the exact procedure depends on your version of Excel (search thru the Help). I actually did this twice, with one button that displays minutes and one that doesn't.
Good luck!
Go to (i.e., highlight) the Cells you want to format. Click on Format.........Cells..........
Choose "Custom" then find one that looks like mm:ss.0
In the input type box add another zero to it
mm:ss.00
and it works. I'm doing this with Excel 2000 (your version might be a bit different but these are the steps.)
Good Luck
Yep, this is what I do. I would add a few comments:
-- My own personal preference is to use the "m:ss.00" format for times greater than 60 seconds and "ss.00" for times under one minute.
-- If you input a number in this format (eg as "1:43.89"), Excel will automatically understand that you mean a time. But it won't give you enough decimal places, so change the format as described by Ahmed to display the hundreds. You can do this for an entire column of empty cells (click on the top heading of the column to select all of them before applying Custom Formatting) then you don't have to keep changing the format.
-- Say you do a time of 32.11 in a 50 free. If you input "32.11" in a cell that is formatted to display "m:ss.00," you will get "38.24.00" displayed. WTF? Excel assumed that you meant "32.11 days" and not seconds and then dutifully displayed it as m:ss.00 (with rollover, 0.11 days is 2 hours, 38 minutes and 24 seconds past midnight). So be sure to include the zeros: input it as "0:32.11."
-- You might find it convenient to record a macro and then assign it to an icon and/or shortcut key. Start the macro recording, change the format as Ahmed described to your liking, and then stop recording. At some point Excel should prompt you for a shortcut key and a macro name. Remember the name: you can assign it to a button on your toolbar -- the exact procedure depends on your version of Excel (search thru the Help). I actually did this twice, with one button that displays minutes and one that doesn't.
Good luck!
