Formula to show hours and minutes between times

[jim101]

I need a formula to tell me how many hours and minutes are between 10:00 pm to 8:00 am

if in cell B2 I have 10/18/11 8:17 AM and in cell C2 I have 10/19/11 10:51 AM the formula should show 10 hours

if in cell B2 I have 10/18/11 5:00 PM and in cell C2 I have 10/19/11 4:45 AM the formula should show 6 hours and 45 minutes

Can this be done using excel 2003? Thanks

 

[barry houdini]

If you need the formula to work for instances where both times are on the same day then try this version

=L2-K2-(INT(L2)-INT(K2))*(K1-L1)-MEDIAN(MOD(L2,1),K1,L1)+MEDIAN(MOD(K2,1),K1,L1)

 

[jim101]

barry, I was just about to post back about that after some testing, thanks