View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lee.bridle@sky.com is offline
external usenet poster
 
Posts: 1
Default Removing Weekends From a Formula...

OK, so, I have the following data:

Batch Start Date and Time - 10/12/08 14:00
Batch Finish Date and Time - 15/12/08 16:55
Batch Duration - =SUM(B2-A2) Which supplies me with the answer: 5.12

However, we shut down over the weekend, so I need to remove the
weekend from the answer, which would give me 3.12.

Trying to do this using Networkdays doesn't seem to include the hours,
so I just get the answer 4, as it touched 4 working days.

Anyone know of something that could help me?

Thanks in advance!

Lee