Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Total Minutes and converting to Hours and Minutes | Excel Discussion (Misc queries) | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
converting hours to days,hours,minutes | Excel Worksheet Functions |