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

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

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

2. ## Re: calculate work hours between two dates of a work week - Sunday to Thursday.

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

3. ## Re: calculate work hours between two dates of a work week - Sunday to Thursday.

This was cross-posted and answered here

4. ## Re: calculate work hours between two dates of a work week - Sunday to Thursday.

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

5. ## Re: calculate work hours between two dates of a work week - Sunday to Thursday.

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

6. ## Re: calculate work hours between two dates of a work week - Sunday to Thursday.

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1