Hi there,
Please help me with a formula for the situation below.
Work week is from Sunday to Thursday (8.30 am to 5.30 pm with one hour lunch break)
Example:
StartDate: 01/06/2010 10:00 AM in A1
EndDate: 09/06/2010 04:00 PM in B1
I need to calculate work hours (in decimal format e.g 30.75 hours) between the above start and end date_time considering a work day is of 8 hours and non-working days are Fridays & Saturdays along with any HolidayList.
I'm Feeling Lucky
Please help me with a formula for the situation below.
Work week is from Sunday to Thursday (8.30 am to 5.30 pm with one hour lunch break)
Example:
StartDate: 01/06/2010 10:00 AM in A1
EndDate: 09/06/2010 04:00 PM in B1
I need to calculate work hours (in decimal format e.g 30.75 hours) between the above start and end date_time considering a work day is of 8 hours and non-working days are Fridays & Saturdays along with any HolidayList.
I'm Feeling Lucky