Date and Time conversion to hours?

I have two date and time fields

A - 01/10/2010 10:33
B - 10/10/2010 15:00

They are formatted as dd/mm/yyyy hh:mm

I am trying to come up with a formula that will tell me the difference in hours (monday to friday) between A and B

So 10/10/2010 15:00 - 01/10/2010 10:33 = X hours

Any ideas?

=(A2-A1)*24

Dom

You should just be able to format the result as General, I get 220.45.

Dom

Just A2-A1 formatted as [h]:mm will give the result as hours and minutes.

Dom

You say you want Monday to Friday hours - are you counting all 24 hours on an MF? 1st Oct 2010 was a Friday so 10:33 to midnight = 13:27 then as the 10th is a Sunday you have to count 5 days Mon 4th to Fri 8th of the following week = 24:00*5+13:27= 133:27 is that the required answer?

To get that then with start time/date in A2 and end time/date in B2 use this formula in C2

=NETWORKDAYS(A2,B2)-1+IF(NETWORKDAYS(B2,B2),MOD(B2,1),1)-NETWORKDAYS(A2,A2)*MOD(A2,1)

format C2 as [h]:mm

note the square brackets