time field - combining columns
Posted on 2014-10-08
I essentially have two columns which i pulled out of a huge text line by using right/left/mid functions. Originally, each row's time would show up as.
0830A (extra verbiage here) So I used a left (A2,4) - 0830 then used that column and did left B2,2 = 08 and right B2,2 =30 for the minute.
I have another column that says if Right(A2,1 = "A", "AM,"PM")
So now I have the hour column, the minute column and the AM/PM columns. Lets say the hour column was STarting in B2, minute would be C2, and AM/PM would be D2.
I need to know a formula I can enter to combine those and for those to be true time fields, that I can make calculations between etc.