# Thread: convert hours:minutes to number of minutes (Excel 2000)

1. ## convert hours:minutes to number of minutes (Excel 2000)

Hello

I import data into Excel from another program. Durations look like this: 14:17. That would be 14 hours and 17 minutes.
Is there a way to convert that (14:17) to 857 (i.e. the total number of minutes for that duration)?

What a huge help this would be!!

Thanks

2. ## Re: convert hours:minutes to number of minutes (Excel 2000)

=HOUR(A1)*60+MINUTE(A1)

3. ## Re: convert hours:minutes to number of minutes (Excel 2000)

If A1 contains the time, then you can use this formula:

<pre>=A1*1440
</pre>

Format the cell containing that formula as a number (Excel will default it to Time). The 1440 in the above is the number of minutes in a day (24*60).

4. ## Re: convert hours:minutes to number of minutes (Excel 2000)

WOW

Fast and fantastic!

Thanks very much!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•