#VALUE!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello from Steved

Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.

=(D3+12)*100

Thankyou
 
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")
 
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")
 
Back
Top