Date/Time Field variance

GoHeels

New Member
Joined
May 14, 2008
Messages
18
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.
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

GoHeels

New Member
Joined
May 14, 2008
Messages
18
That returns a decimal value. My apologies, I failed to mention that the date/time fields are set to TEXT.
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
If you want it to show as 24 hours, 11 minutes, use the same formula and format the result cell as:

[h] "hours, " m "minutes"
 

Watch MrExcel Video

Forum statistics

Threads
1,127,581
Messages
5,625,613
Members
416,124
Latest member
DeMoNloK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top