converting days, hours and minutes to minutes

W

wowo35

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.
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hours and Minutes Data format 3
Calculating Hours and minutes 5
Formula to convert Hours to Days, Hours Minutes 1
Calculate Days, Hours, Minutes 1
Converting time to Minutes 2
Convertin hours into days, hours and minutes 6
Convert Decimal Minutes to Hours-Minutes-Seconds 3
Converting hour/minutes to hours/hundredths 1

Top