Excel 2007 : Calculating working hours between dates including weekends

Hi All,

I am needing to calculate the hours between 2 dates (including weekend), but only counting the working hours.

I have had a go, but my fomula seems to be calculating a different answer, so somewhere along the lines it's just not right!!!

I have a start date of 29/01/2012 18:34:00 and end date of 30/01/2012 16:39:00, with working hours being Mon - Sun 08:00:00 - 17:30:00.

I manually worked this out to be 18:09:00, but as you can see on the attachment my formula works it out as 17:05:00!!!

Anyone see where its gone wrong!!! (has it subtracted the 1:04 on the start date passed teh 17:30:00 threshold!) as i don't want this to happen!!

cheers

Donna