Time differences between two dates

Hello All,

I have an excel sheet with 4 columns: Start date, Start Time, End Date, End Time. I would like to know the time duration between these two dates in the fifth column. I am able to use the Mod function =MOD(D4-B4,1) to get the time duration between the times but don't know how to incorperate the date cells in it Because some trial experiment can go on for more than a day. Please have look at the sample excell sheet attached. Any help would be appreciated. Thnx

Try this formula in E2 and copy down;

Formula:

Please Login or Register  to view this content.

And format your cells as [h]:mm

#VALUE! error. see image for details please (I did format the cells to [h]:mm).

It's because your dates are stored as text. Works for me though Excel 2013?

Type in your dates again to test.

excel 2010. The dates are stored as 'General', what format should they be. I tried switching to Date format, same results.

Try changing your dates to numbers. Many ways to do this but just retype them in (not the format).

See how the dates are left justified, that's because they are text. Once they are a number they will be right-justified.

Don't know why the formula works for me but not you.