software

Hi Guys,

I need help to convert hours (hh:mm:ss - 06:32:00) in minutos (392 minutes)

Thanks,

Eder Taffarel
Brazil

Hi Eder,
Multiply Excel Time by 24 to get hours since time is a fraction of a day, then
Multipl y hours by 60 to get minutes
=A1 * 1440

More information on Date and Time
www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Eder Taffarelquot; lt;Eder gt; wrote in message
...
gt; Hi Guys,
gt;
gt; I need help to convert hours (hh:mm:ss - 06:32:00) in minutos (392 minutes)
gt;
gt; Thanks,
gt;
gt; Eder Taffarel
gt; Brazil
=HOUR(A1)*60 MINUTE(A1)

Be sure to format the cell as general.Or if no calculations need to be done just custom format [m]

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;David McRitchiequot; gt; wrote in message
...
gt; Hi Eder,
gt; Multiply Excel Time by 24 to get hours since time is a fraction of a day,
gt; then
gt; Multipl y hours by 60 to get minutes
gt; =A1 * 1440
gt;
gt; More information on Date and Time
gt; www.mvps.org/dmcritchie/excel/datetime.htm
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Eder Taffarelquot; lt;Eder gt; wrote in message
gt; ...
gt;gt; Hi Guys,
gt;gt;
gt;gt; I need help to convert hours (hh:mm:ss - 06:32:00) in minutos (392
gt;gt; minutes)
gt;gt;
gt;gt; Thanks,
gt;gt;
gt;gt; Eder Taffarel
gt;gt; Brazil
gt;
gt;