G Guest Dec 11, 2005 #1 Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou
Hello from Steved Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510. =(D3+12)*100 Thankyou
J JE McGimpsey Dec 11, 2005 #3 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")
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")
G Guest Dec 11, 2005 #5 Thankyou JE exactly what was required. JE McGimpsey said: 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") Click to expand...
Thankyou JE exactly what was required. JE McGimpsey said: 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") Click to expand...
