B Brenda Rueter Mar 2, 2005 #1 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!
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!
N Niek Otten Mar 2, 2005 #2 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 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
J Jason Morin Mar 2, 2005 #3 =A1*24*60 Format as General ( shortcurt: press <Ctrl><Shift><~> ) HTH Jason Atlanta, GA
B Brenda Rueter Mar 2, 2005 #4 I get 0:00 every time. Jason Morin said: =A1*24*60 Format as General ( shortcurt: press <Ctrl><Shift><~> ) HTH Jason Atlanta, GA Click to expand...
I get 0:00 every time. Jason Morin said: =A1*24*60 Format as General ( shortcurt: press <Ctrl><Shift><~> ) HTH Jason Atlanta, GA Click to expand...
N Niek Otten Mar 2, 2005 #5 You probably have minutes and seconds, not hours and minutes. Multiply once more with 60. -- Kind Regards, Niek Otten Microsoft MVP - Excel
You probably have minutes and seconds, not hours and minutes. Multiply once more with 60. -- Kind Regards, Niek Otten Microsoft MVP - Excel
M Myrna Larson Mar 3, 2005 #7 Save your fingers and stop typing unnecessary + signs. The formula should be =A1*24*60.
