#VALUE!

[Steved]

Hello from Steved

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

=(D3+12)*100

Thankyou

[Bernard Liengme]

Would formatting the cell to hh.mm not do?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello from Steved
>
> Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
>
> =(D3+12)*100
>
> Thankyou

[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")

In article <[email protected]>,
Steved <[email protected]> wrote:

> Hello from Steved
>
> Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
>
> =(D3+12)*100
>
> Thankyou

[JE McGimpsey]

No, since D3 is text.

In article <#[email protected]>,
"Bernard Liengme" <[email protected]> wrote:

> Would formatting the cell to hh.mm not do?

[Steved]

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 <[email protected]>,
> Steved <[email protected]> wrote:
>
> > Hello from Steved
> >
> > Below is returning #VALUE! I'm trying to turn 3:10 PM into 1510.
> >
> > =(D3+12)*100
> >
> > Thankyou
>