Calculate downtime between two dates exclude weekends

Hi,

I'm new to this forum and i need to check the downtime in minutes for a start and end date, whereby it needs to exclude weekends.

i have tried using the networkdays, but it only return me with the day, but i need the actual downtime in minutes. I really have no idea Can assist ? or point me to useful sources that for newbie like able to follow?

hi
if a machine is off for a whole day, do you want that counted as 24 hours or only a work day (eg 8 hours)? if the latter, how long is your working day?

whole day, as 24 hours

Start date :Oct 16, 2012 8:00:00 AM
End Date : Oct 22, 2012 10:00:00 AM

But it returns 24.41666667 - not sure if this is minutes ??

try this

it should return total hours in whole numbers and decimals (ie 9 hours 30 minutes = 9.5)

=24*(NETWORKDAYS(A2,B2)-MOD(A2,1)-(1-MOD(B2,1)))

Ya, i guess is good to include the file for better understanding on the problem.

I working on calculating the machine downtime where the possible is:
1. The machine operation could be 31 days * 24 hours
2. The machine operation could be 23 days * 8 hours (where by the working hours is from 9AM till 5PM, exclude weekends)

I have difficulties in calculating the downtime for the No. 2 above.