Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format
I have created a chart for my daughter for a science experiement. All 12
data entries are fine for all categories except one. when I type in 29:04 as in 29 minutes 04 seconds, I get all kinds of weird things happen, I have set the cell to be mm:ss but apparently it looks at 29 as hours and creates a time and or date. This is critical for the scoence data to be graphed out and imperative I create this cell to reflect 29 minutes 04 seconds as all the other times are already graphed. How can I get this cell to reflect correctly? -- Thanks in advance, Kim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format
Hi Kim,
I think the required format is to explicitly specify no hours as in 00:29:04 (would need to check further why this is so if it is - seems to work ?) "Kim K" wrote: I have created a chart for my daughter for a science experiement. All 12 data entries are fine for all categories except one. when I type in 29:04 as in 29 minutes 04 seconds, I get all kinds of weird things happen, I have set the cell to be mm:ss but apparently it looks at 29 as hours and creates a time and or date. This is critical for the scoence data to be graphed out and imperative I create this cell to reflect 29 minutes 04 seconds as all the other times are already graphed. How can I get this cell to reflect correctly? -- Thanks in advance, Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |