converting days, hours and minutes to minutes
 

I do turn around times at work. The info is gotten from a report in
powervision ( a cerner product) and then exported to excel. The cells
populate this way (example) 01 15:15, the 01 is one day if there is no day
its easy to plug in a formula to convert to minutes but when there are days
01, 02 ect it wont convert. Does anyone know of a way to convert this into
minutes in excel? Or a way to average the days hours minutes? I used to be
able to export to comma and it would work but alas this is no longer the case
for some reason.

converting days, hours and minutes to minutes
 

Try this:

A1 = 01 15:15

Excel considers that a TEXT string.

This formula:

=IF(COUNT(FIND(" ",A1)),LEFT(A1,FIND(" ",A1)-1)+MID(A1,FIND("
",A1)+1,10),A1)*1440

Returns 2355

You might be able to use this slightly shorter version but it's not as
robust as the one above:

=IF(ISTEXT(A1),LEFT(A1,FIND(" ",A1)-1)+MID(A1,FIND(" ",A1)+1,10),A1)*1440


--
Biff
Microsoft Excel MVP


"wowo35" wrote in message
...
I do turn around times at work. The info is gotten from a report in
powervision ( a cerner product) and then exported to excel. The cells
populate this way (example) 01 15:15, the 01 is one day if there is no
day
its easy to plug in a formula to convert to minutes but when there are
days
01, 02 ect it wont convert. Does anyone know of a way to convert this
into
minutes in excel? Or a way to average the days hours minutes? I used to
be
able to export to comma and it would work but alas this is no longer the
case
for some reason.