Excel – Calculating time difference between two date/times from two columns in Excel

microsoft excelmicrosoft-excel-2010worksheet-function

I have 5 columns: Start Date, Start Time, End Date, End Time and Duration. I need to calculate the duration between the Start Date/Start Time and the End Date/End Time. I tried just subtracting the end time from the start time, but I am having issues when it spans two days. I haven't been able to find a solution that doesn't require me to add two new columns (Start Date/Time and End Date/Time). Any ideas?

enter image description here

Best Answer

I have found the errors in my way. I had to do the following:

  • Format Start Date/End Date as mm/dd/yyyy
  • Format Start Time/End Time as HH:MM:SS (24 hr format***)
  • Then I was able to use the formula (in R2) =(P2+Q2) - (N2+O2)

enter image description here

Related Question