B
Brenda Rueter
Is there a function to convert 1:50 as an hour/minute time (one hour, 50
minutes) into the number of minutes (110 minutes)? TIA!
minutes) into the number of minutes (110 minutes)? TIA!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
If you only want to display it that way, Format Custom, [mm]
If you need to calculate with the minutes as a number, multiply by 24*60
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
If you need to calculate with the minutes as a number, multiply by 24*60
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
J
Jason Morin
=A1*24*60
Format as General ( shortcurt: press <Ctrl><Shift><~> )
HTH
Jason
Atlanta, GA
Format as General ( shortcurt: press <Ctrl><Shift><~> )
HTH
Jason
Atlanta, GA
B
Brenda Rueter
I get 0:00 every time.
Jason Morin said:=A1*24*60
Format as General ( shortcurt: press <Ctrl><Shift><~> )
HTH
Jason
Atlanta, GA
N
Niek Otten
You probably have minutes and seconds, not hours and minutes. Multiply once
more with 60.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
more with 60.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
B
Brenda Rueter
Ah ha! A1=1:50....
If I type =+a1*24*60, then I get 110. Thanks all!
If I type =+a1*24*60, then I get 110. Thanks all!
M
Myrna Larson
Save your fingers and stop typing unnecessary + signs.
The formula should be =A1*24*60.
The formula should be =A1*24*60.