Time and Date Summing

[Michael S2004]

I have one columb with Date, I have a second columb with Time. mm/dd/yy and 16:22 (military time)

In the second row I have a newer Date and Time.

I would like to figure the amount of hours ( to the tenth) between the two rows.

Could you please tell me what the formula is?

 

[Zack Barresse]

make sure the two date columns are formatted the same, in your formula column, take latestdate - earlierdate. format the cell to number w/ 1 decimal point.

if you want hours add * 24 in your formula cell.

hope this helps.

 

[BuddieB]

Simply add the date and time for each row together to combine into one date reading that XL will read.

Then you can subtract one date from the other, the resulting number is a difference in "days" which is waht Xl uses for times.

Once you have this, multiply it by 24 to get it into hours and format the cell to be #.0 to give you "tenths"

Book1
	A	B	C	D
1	Date	Time	Combined
2	1/20/2004	16:00:00	1/20/200416:00
3	1/22/2004	11:30:00	1/22/200411:30
4		Difference	43.5
5		SingleFormula:	43.5
6
SGH Template