Hello,

I would like to calculate the time elapsed between an end date, end time, start date, and start time columns (4 columns) and have the answer show in hours and minutes. I would also like to show a blank cell if any one of these attributes is not populated in the respective column(s).

I thought I had calculated the time elapsed using a very basic calculation with the exception of addressing the blank cell issue. However, when I create a pivot table to summarize each individual row for time elapsed, the totals are wrong. The pivot table "Sum" for 2014 for instance shows as "1/16/1900 10:47: 00 AM" in the formula bar, and as 10:47 in the pivot table, and the answer from the table when I filter the time elapsed is 394:47:00.

I am certain that some of the issue is formatting, but have tried everything I can think of to fix that, and have run out of ideas.

Any help would be greatly appreciated.