I have extracted date from a radiology programme that has times of exams but it is shown in DD HH MM format (days, hours, minutes)
I would like to easily convert this to a time format so I can find minimum, maximum and average time values. I have over 5000 data entries so I would prefer not to do this all manually.
For instance, how would i convert text of 00D 01H 46M (in cell A1) into a time format showing hh:mm.
Bookmarks