Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Formula Excluding Weekends | Excel Discussion (Misc queries) | |||
Can excel calc the difference between 2 dates removing weekends? | Excel Discussion (Misc queries) | |||
removing weekends | Excel Worksheet Functions | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) | |||
Removing holidays and weekends , networkdays | Excel Discussion (Misc queries) |