Preface this with thanks to any assistance provided. I have two fields that are imported into MS Excel via .pdf extractor. The fields contain date/time values in the following format:
Field A
6/4/08 14:14
Field B
6/5/08 14:25
What I need to do is create a separate column that formulates the variance from Field B & A. For the example above, the result would yield 24 hours, 11 minutes (or can this be converted to decimal in days?). Can this be done with the fields in this format. Or should first perform a text to column and split out the times and then perform the calculation? If I do this, I would need to concatenate the date variance and time variance into a single field.
Again, thanks in advance for any assistance.
Field A
6/4/08 14:14
Field B
6/5/08 14:25
What I need to do is create a separate column that formulates the variance from Field B & A. For the example above, the result would yield 24 hours, 11 minutes (or can this be converted to decimal in days?). Can this be done with the fields in this format. Or should first perform a text to column and split out the times and then perform the calculation? If I do this, I would need to concatenate the date variance and time variance into a single field.
Again, thanks in advance for any assistance.