#VALUE!

G

Guest

Hello from Steved

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

=(D3+12)*100

Thankyou
 
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")
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3.10 PM to 24 hour time please ( 1510 ) 5
3.02 PM ( Decimal Point )to 1502 3
106% to this please 6% 7
Conditional Formatting Rules Manager Excel 2007 3
Weeknum Within a Range 5
I do not want the minus sign 5
Insert a Decimal 3
Value 0 3

Top