View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wowo35 wowo35 is offline
external usenet poster
 
Posts: 1
Default 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.