Calculate number of hours between 2 dates

[LearnMeExcel]

Hi All Excel 2010

	A	B
1	From	To
2	15/03/2013	21/03/2013
3	18:00	12:25
4
5
6	I want to calculate number of hours from the date and time in column A To date ad time in column B
7	How I could do it and round Number of hours Down
8	From 12:25 to 12:00

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

 

[beastman59]

I googled and found this: Calculate Hours Between Two Dates and Times in Excel | Excel Semi-Pro

hope it helps

 

[Snakehips]

LearnMeExcel,

There may well be a more elegant solution but given that you appear to have dates and times in separate cells, does this help....

Excel 2007
	A	B	C	D	E
1	From	To			Hours
2	15/03/2013	21/03/2013			155
3	01:00	12:25
Sheet1

Cell Formulas
Range	Formula
E2	=((B2-A2)*24)+((N(MAX(HOUR(A3),HOUR(B3))-MIN(HOUR(A3),HOUR(B3))))*(IF(A3>B3,-1,1)))

Hope that helps.

 

[JB_Scotland]

or in E2

=INT(((B2+B3)-(A2+A3))*24)