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<attarkon.ee )


"Steved" wrote in message
...
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<attarkon.ee )


"Steved" wrote in message
...
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.