Convert Hours in Minutos

E

Eder Taffarel

Hi Guys,

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

Thanks,

Eder Taffarel
Brazil
 
P

Peo Sjoblom

Or if no calculations need to be done just custom format [m]

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


David McRitchie said:
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
http://www.mvps.org/dmcritchie/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Eder Taffarel said:
Hi Guys,

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

Thanks,

Eder Taffarel
Brazil
Click to expand...
Click to expand...
 
Top