Weekends

macrogeek

New Member
Joined
Nov 24, 2005
Messages
4
Please can someone assist me with this one.

I need to calculate the time in hours from two dates, simple enough but I need to remove the following time from the calculation

1. The weekend (determined as 00:00 saturday - 11:59 sunday)
2. The days must be 08:00 - 16:00 or another predefined time

Any ideas greatly received. :eek:
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,118,762
Messages
5,574,091
Members
412,567
Latest member
mm1
Top