time to decimal

  • Thread starter Thread starter Louie
  • Start date Start date
L

Louie

I have numbers like 283 hours 13 min 7 sec 283:13:07 in an excel work
sheet.

I want to convert this to decimal minutes. What formula can accomplish
this?

I hope someone can help because I have lots of them to do.

Thanks for any help,
 
=A1*24*60

Format as General or number, not as Time, which is what Excel does automatically

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have numbers like 283 hours 13 min 7 sec 283:13:07 in an excel work
| sheet.
|
| I want to convert this to decimal minutes. What formula can accomplish
| this?
|
| I hope someone can help because I have lots of them to do.
|
| Thanks for any help,
|
|
|
 
Back
Top