Calculating Difference in times and dates

[jeff07kp]

Hopefully someone can help me,

I have
Coumn A Column B Column C Column d
7/15/08 13:00 7/20/08 23:00

I need to calculate the difference time including dates,
does anyone know how to calculate this???

 

[xld]

=(C2+D2)-(A2+B2)

and format as d: hh:mm

 

[ramp76]

Hopefully someone can help me,

I have
Coumn A Column B Column C Column d
7/15/08 13:00 7/20/08 23:00

I need to calculate the difference time including dates,
does anyone know how to calculate this???

I'm not sure about the time calculation, but here is a formula that will calculate the amount of days between two dates: =datedif(a1,a3,d)

I found this forumula at this website: http://www.theexceladdict.com/_t/t040303.htm

You can check out this page and it will explain the formula and tells you how to calculate for years, months, days, etc. Unfortunately, it doesn't mention anything about calculating times.

I just googled "finding the difference between two times in excel" and found this website: http://office.microsoft.com/en-us/excel/HP030561081033.aspx

This may help you with the time part. I hope this helps you out. Good luck!

 

[xld]

I'm not sure about the time calculation, but here is a formula that will calculate the amount of days between two dates: =datedif(a1,a3,d)

A bit simpler

=A3-A1

 

[jeff07kp]

For example I would like to calculate in cell E
total hours between the two periods (7/20/08 -07/15/08)+ (23:00-13:00) = 5days and 10 hours = 130 hours

Although this seems as a simple calculation what if my final time in column d is less than the time in Column B, then this equation wouldn't work. How can I get this total time??

 

[Scott Huish]

Use the formula xld gave you first, you don't subtract the dates and then add the subtracted times, you add the date to each time and subtract those. Format as [h]:mm

Excel Workbook
	A	B	C	D	E	F
2	7/15/2008	13:00	7/20/2008	23:00		130:00
Sheet1

 

[jeff07kp]

Thanks to all this worked!!1