How to find the duration between date & time.

How to find the duration between date & time.

Please find below relevant details.

Cell ref. A2 B2 C2 D2
Start Date Start Time End Date End Time
4/25/2015 7:00 AM 4/28/2015 9:00 PM

How many "DAYS" between above dates?
Extra time "HOURS"?
Extra time "MINUTES?

Thanks for your support.

Dates and times in excel are just numbers
It is only the formatting of them that shows them as dates
The integer bit of the number is the days since 1st Jan 1900
The fraction bit is the time so .25 is 6 am and .75 is 6 pm
to get duration just subtract one from the other, if the difference is 1.75 then duration is 1 day and 18 hours

However I do agree with Pepe this is basic stuff, go on a course, look in the manual or read some of the forum replies

=IF(LEN(R7),DATEDIF(R7,$C$1,"y")&" years, "&DATEDIF(R7,$C$1,"ym")&" months ","")

Untitled.jpg

Syed82

Can you do the formula my attached file?. It will be very helpful to me.

Irfan