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