Convert Time to Minutes

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!
 
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
 
J

Jason Morin

=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
 
M

Myrna Larson

Save your fingers and stop typing unnecessary + signs.

The formula should be =A1*24*60.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert an elapsed time in minutes to Days hours and minute 1
Overtime 9
Converting time formats in Excel 4
Coverting to minutes 2
Quarter Hour time conversions for timesheet 2
hour minutes to minutes 2
convert hours to minutes 4
Change Number to Time 3

Top