| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert Time to Minutes
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! |
|
#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 "Brenda Rueter" wrote in message ... 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! |
|
#3
|
|||
|
|||
|
=A1*24*60
Format as General ( shortcurt: press <Ctrl<Shift<~ ) HTH Jason Atlanta, GA -----Original Message----- 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! . |
|
#4
|
|||
|
|||
|
I get 0:00 every time.
"Jason Morin" wrote in message ... =A1*24*60 Format as General ( shortcurt: press <Ctrl<Shift<~ ) HTH Jason Atlanta, GA -----Original Message----- 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! . |
|
#5
|
|||
|
|||
|
You probably have minutes and seconds, not hours and minutes. Multiply once
more with 60. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Brenda Rueter" wrote in message ... I get 0:00 every time. "Jason Morin" wrote in message ... =A1*24*60 Format as General ( shortcurt: press <Ctrl<Shift<~ ) HTH Jason Atlanta, GA -----Original Message----- 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! . |
|
#6
|
|||
|
|||
|
Ah ha! A1=1:50....
If I type =+a1*24*60, then I get 110. Thanks all! "Niek Otten" wrote in message ... You probably have minutes and seconds, not hours and minutes. Multiply once more with 60. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Brenda Rueter" wrote in message ... I get 0:00 every time. "Jason Morin" wrote in message ... =A1*24*60 Format as General ( shortcurt: press <Ctrl<Shift<~ ) HTH Jason Atlanta, GA -----Original Message----- 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! . |
|
#7
|
|||
|
|||
|
Save your fingers and stop typing unnecessary + signs.
The formula should be =A1*24*60. On Thu, 3 Mar 2005 08:55:18 -0500, "Brenda Rueter" wrote: Ah ha! A1=1:50.... If I type =+a1*24*60, then I get 110. Thanks all! "Niek Otten" wrote in message ... You probably have minutes and seconds, not hours and minutes. Multiply once more with 60. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Brenda Rueter" wrote in message ... I get 0:00 every time. "Jason Morin" wrote in message ... =A1*24*60 Format as General ( shortcurt: press <Ctrl<Shift<~ ) HTH Jason Atlanta, GA -----Original Message----- 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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What function do I use to convert "time" to minutes? | Excel Worksheet Functions | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
| convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How do I convert Military Time to minutes? | Excel Worksheet Functions | |||
Linear Mode
