Data exists in 2 format:
both in separate columns ( see worksheet 1 column A and B)
2. date and time together (see worksheet 1 column C)
I need to calculate the duration between the 2 data for the whole column - see column D and E.
My problem is that it is more accurate to work with the calculation if the data format is in date and time together, ie. no 2. instead of 1a and 1b. However, I have data format like 1a and 1b sometimes.
Thus I need:
1 macro to be able to combine 1a and 1b and then do an interval calculation; and if 2. exists, then use 2. for interval calculation
-"Date" will always be at column A
-"Time" will always be at column B
-"Date.Time" will always be at column C
-if either data is not available, it will be blank. For example, data in Column A and B exists but not Column C, then Column C will be blank. OR Data in Column C exists but not in Column A and B, then Column A and B will be blank.