J James Nix New Member Aug 22, 2017 #1 I have a file that was downloaded from an medical record. the data I want to analyze is in text form. I want columns A and B to be converted to time and column c to calculate the elapsed time in minutes. Attachments time query.xlsx 9.2 KB · Views: 3
I have a file that was downloaded from an medical record. the data I want to analyze is in text form. I want columns A and B to be converted to time and column c to calculate the elapsed time in minutes.
B bosco_yip Excel Ninja Aug 22, 2017 #2 In C2, formula copied down : =(TEXT(B2,"00\:00")-TEXT(A2,"00\:00"))*24*60 Regards Bosco Attachments time query(1).xlsx 10.4 KB · Views: 6 Last edited: Aug 22, 2017
