Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |