convert days hours minutes seconds to just minutes

**hollylynn** · 07-29-2011, 06:00 AM

Hi I have the number of days hours minutes and seconds (dd hh:mm:ss) in one cell and want to convert to just minutes ? Tried using =CONVERT but doesn't seem to work, any ideas?

**Cookstein2** · 07-29-2011, 06:12 AM

how have you entered the value into the cell that is formatted "dd hh:mm:ss"

if for example you wanted to enter 2 days and 10 hours and you typed "2 10:00:00" it wouldnt work.

You would need to type "02/01/1900 10:00:00"

**Cookstein2** · 07-29-2011, 06:38 AM

ok if your time is in cell A1 in your dd hh:mm:ss format then put this in your results cell

Please Login or Register  to view this content.

**daddylonglegs** · 07-29-2011, 06:40 AM

Assuming the data is text (not a formatted elapsed time value) then try this formula to give minutes

=(LEFT(A1,2)+RIGHT(A1,8))*1440

alternatively, if it is a formatted elapsed time value then you only need to multiply by 1440, i.e.

=A1*1440

In either case I assume that your data is in A1 - format result cell as number or general