time to decimal

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louie - 06 Nov 2007 15:10 GMT

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,

Reply to this Message

Niek Otten - 06 Nov 2007 15:19 GMT

=A1*24*60

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

Signature

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.
[quoted text clipped - 5 lines]
|
| Thanks for any help,

Reply to this Message

Louie - 06 Nov 2007 15:28 GMT

Thank you very much. You saved me lots of work.

> =A1*24*60
>
[quoted text clipped - 11 lines]
> |
> | Thanks for any help,

Reply to this Message

Rate this thread: