Convert Days:Hours:Minutes:seconds to minutes.

**Kevingardner1** · 05-25-2011, 07:07 AM

I have a spread sheet with a colum showing average time to complete a task. This is currently shown as Days:Hours:Minutes:Seconds (4:19:33:19). I meed it to be shown purely as minutes, or at least as hours and minutes.

Is there an easy way to do this?

**NBVC** · 05-25-2011, 07:55 AM

Try:

=LEFT(A1,FIND(":",A1)-1)*1440+MID(A1,FIND(":",A1)+1,20)*24

formatted as General or Number with Decimals...

**Kevingardner1** · 05-25-2011, 08:23 AM

You nailed it, bang on.

Thanks so much.

**Sommer** · 06-03-2014, 11:48 AM

Hello,

I apologise in advance - I'm pretty novice at this.

I'm trying to do a similar thing to everyone else. I need to convert Days, Hours, Minutes and seconds into minutes. Currently our system supplies the data in the format 2d 9h 4m 0s. I've come to terms with the fact that I will have to manually go in and change it to dd:hh:mm:ss which is fine.

I've tried using the calculation you gave before i.e. =LEFT(A1,FIND(":",A1)-1)*1440+MID(A1,FIND(":",A1)+1,20)*24 but it's coming out with some strange figures.

For example; I used it to calculate 00d 5h 38m 5s and it came back with 5.63. Is this rounded up to hours or just the number representative of the time?

**6StringJazzer** · 06-03-2014, 06:44 PM

Sommer, if the answers in this thread don't apply to your problem, then please start a new thread with your question.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.