Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formatting
Hello I have a column formatted as time . so 141:29:51 looks like this in
the formula bar 01/05/1900 9:29:51 PM the problem is the one cell is 158:121:38 the formula bar reads 158:121:38 so when I try to add the column I get #Value. Now I tried reformatting this cell and eventhough it is formatted to time - 33:30:55 when I sum the column I still get #VALUE as an answer HELP! and thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formatting
Hi
The problem is your value 158:121:38 is a Text value not a Time/Date value. It looks like a typo, and should be 158:21:38 as it is clearly impossible to have 121 minutes in an hour. Change the value, then click on your cell with the formula again and press Enter. -- Regards Roger Govier "Wanna Learn" wrote in message ... Hello I have a column formatted as time . so 141:29:51 looks like this in the formula bar 01/05/1900 9:29:51 PM the problem is the one cell is 158:121:38 the formula bar reads 158:121:38 so when I try to add the column I get #Value. Now I tried reformatting this cell and eventhough it is formatted to time - 33:30:55 when I sum the column I still get #VALUE as an answer HELP! and thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
time formatting
Thank you Roger. I must have looked at this 50 times and did not catch that.
thank you so much "Roger Govier" wrote: Hi The problem is your value 158:121:38 is a Text value not a Time/Date value. It looks like a typo, and should be 158:21:38 as it is clearly impossible to have 121 minutes in an hour. Change the value, then click on your cell with the formula again and press Enter. -- Regards Roger Govier "Wanna Learn" wrote in message ... Hello I have a column formatted as time . so 141:29:51 looks like this in the formula bar 01/05/1900 9:29:51 PM the problem is the one cell is 158:121:38 the formula bar reads 158:121:38 so when I try to add the column I get #Value. Now I tried reformatting this cell and eventhough it is formatted to time - 33:30:55 when I sum the column I still get #VALUE as an answer HELP! and thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formatting | Excel Discussion (Misc queries) | |||
Time Formatting | Excel Discussion (Misc queries) | |||
Time formatting | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |