Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
Hello from Steved
Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
Would formatting the cell to hh.mm not do?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steved" wrote in message ... Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
D3 contains Text, which is giving you the #VALUE! error, since the +
operator requires two numeric arguments. If you have "3:10 PM" in cell D3, one way to convert it to 1510 is =TEXT(TIMEVALUE(D3),"hhmm") which will return text. If you want the numeric value one thousand five hundred ten: =--TEXT(TIMEVALUE(D3),"hhmm") In article , Steved wrote: Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
No, since D3 is text.
In article , "Bernard Liengme" wrote: Would formatting the cell to hh.mm not do? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#VALUE!
Thankyou JE exactly what was required.
"JE McGimpsey" wrote: D3 contains Text, which is giving you the #VALUE! error, since the + operator requires two numeric arguments. If you have "3:10 PM" in cell D3, one way to convert it to 1510 is =TEXT(TIMEVALUE(D3),"hhmm") which will return text. If you want the numeric value one thousand five hundred ten: =--TEXT(TIMEVALUE(D3),"hhmm") In article , Steved wrote: Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|