calculate work hours between two dates of a work week - Sunday to Thursday.

**azkhan** · 06-13-2010, 04:03 AM

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)

Example:
StartDate: 01/06/2010 10:00 AM in A1
EndDate: 09/06/2010 04:00 PM in B1
StartTime: 08:30 am in A4
EndTime: 05:30 pm in A5

I need to calculate working hours (in decimal format e.g 30.75 hours) between the above start and end date/time considering a work day is of 9 hours and non-working days are Fridays & Saturdays along with any HolidayList.

I'm Feeling Lucky

**Weezy** · 06-14-2010, 04:11 PM

is it ok to bump a thread that i am watching and trying to solve? Hope so...

**daddylonglegs** · 06-14-2010, 04:25 PM

This was cross-posted and answered here

**Weezy** · 06-14-2010, 04:46 PM

alright dang it. I had a different approach i guess i am jsut slow. Thanks for the info.

**daddylonglegs** · 06-14-2010, 05:26 PM

Still, feel free to post if you feel you have something extra to contribute.........

**azkhan** · 06-24-2010, 06:21 AM

Originally Posted by daddylonglegs

Still, feel free to post if you feel you have something extra to contribute.........

Hi All,

Please accept my apologies for the trouble. I was unaware that if I cross post any thread I should just mention the link of that post. And I completely forgot to mark it as 'solved' after I have got the answer.

Once again, apologize sincerely for the inconvenience.

Cheers,
Az