Hello from Steved

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

=(D3+12)*100

Thankyou

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

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

No, since D3 is text.

In article ,
"Bernard Liengme" wrote:

Would formatting the cell to hh.mm not do?

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