How to count Working hours b/w two date and time including Saturday

Hello to all

i want to calculating working hours in b/w two dates and times.
my Start date(A2) 03-feb-2014 4.00 PM --'Monday
my end date(b2) 08-feb-2014 1.00 PM --'Saturday

my office timeings is monday to friday - 9.00 Am to 6.00 Pm, and saturday 9.00 Am to 1.00 PM only

when am useing networking days funtcion for the above,am getting result excecpt saturday, for this agin am usinig networkday+weekday
this is working fine for me, but am not able to counting hours in
here is my formula
=(8*(NETWORKDAYS(A2,B2))+4*(INT((WEEKDAY($A2-7)-$A2+$B2)/7)))-24*(MOD(B2,1)-MOD(A2,1))
for this am getting 43 hours instead of 38 hours

because my work started in feb-03 time of 4-pm, i want calculate only 2 hours for the Monday.
how to capture time time and calculate?
note: if time greater than 6Pm , work hours will calculate for the next day.

thanks for advance

Pl see attached file with formula.

Originally Posted by daddylonglegs

If the working day is 09:00 until 18:00 that's 9 hours....but you are counting 8 for each working day, are you accounting for a lunch break?

If you want to consider lunch breaks for partial days then I think you need to define lunch break times too, e.g. 13:00 until 14:00, otherwise if your period starts at 13:00 how do I know if that is after lunch or before, total hours will be different depending on which it is.

my lunchtime is 1.00PM to 2.00 PM.
yes what u said is correct, that's why i remove the "8" for couning.
but am not getting expected result, due to round function am not getting time format when dates are different and differ time's.