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!

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!

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


.

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!


.

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!


.

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!


.

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!


.