This group was so helpful last time that I wondered if I might beg another question of you.
I have enclosed a small sample worksheet of a report that is downloaded as a text file from mainframe at work.
The time columns are not reflected as such as you can see. There are no colons in the downloaded text. I need to make a column that calculates the difference in time – discharge-arrival time (ColumnH –ColumnG) – to show the total amount of hours/minutes spent in my department. Some of the times cross midnight e.g. row 23 a child that arrived in the hospital at 9:35pm and left at 4:20am.
Can you design something to change the time columns G and H to a format recognized by excel so I can perform calculations?
Please make the instructions very simple – I’m not very good with this stuff. (The actual spreadsheets are very large with > 5000 rows.) Many thanks in advance.