Hours and Minutes to minutes

Hello From Steved

=HOUR(A1)*60+MINUTE(A1)
I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
should be 407. I formatted the cell mm

Thankyou.

It helps if one thinks clearly I suppose.

I formatted the cell as General and now all's well.

"Steved" wrote:

> Hello From Steved
>
> =HOUR(A1)*60+MINUTE(A1)
> I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
> should be 407. I formatted the cell mm
>
> Thankyou.
>

Hi Steve

Format the cell as general

Thanks Martin

"MartinW" wrote:

> Hi Steve
>
> Format the cell as general
>
>
>

Hi

Aside formatting, you formula is too compliced for this case. Use:
=A1*24*60


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"Steved" <Steved@discussions.microsoft.com> wrote in message
news:4D4521E2-4123-4205-BF45-26135464DACF@microsoft.com...
> Hello From Steved
>
> =HOUR(A1)*60+MINUTE(A1)
> I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
> should be 407. I formatted the cell mm
>
> Thankyou.
>

Thankyou Arvi

"Arvi Laanemets" wrote:

> Hi
>
> Aside formatting, you formula is too compliced for this case. Use:
> =A1*24*60
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvi.laanemets<at>tarkon.ee )
>
>
> "Steved" <Steved@discussions.microsoft.com> wrote in message
> news:4D4521E2-4123-4205-BF45-26135464DACF@microsoft.com...
> > Hello From Steved
> >
> > =HOUR(A1)*60+MINUTE(A1)
> > I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
> > should be 407. I formatted the cell mm
> >
> > Thankyou.
> >
>
>
>