S
Steved
Hello from Steved
Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
=(D3+12)*100
Thankyou
Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
=(D3+12)*100
Thankyou
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
Would formatting the cell to hh.mm not do?
J
JE McGimpsey
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")
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")
J
JE McGimpsey
No, since D3 is text.
S
Steved
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")