Hours between two dates excluding weekends ( Friday and Saturday)

[mahmoudsamir]

Hi ,

Need help to create a formula to calculate hours between two dates excluding weekends ( Friday and Saturday )

Bi Version :

4.2 Interanet Pack 5 Patch 5

Version: 14.2.5.2853

Thanks

[denis_konovalov]

I have fixed your tag, please select more careful next time.

[mahmoudsamir]

Hi Ayman,

Would you please show me a sample of case 1 and 2. sorry, I didn't get what you mean.

weekends should be days number 6 & 7

[ayman_salem]

try this:

=TimeBetween([Begin Date];[End Date];HourPeriod) - TimeBetween([Begin Date];[End Date];WeekPeriod)*2*24

[mahmoudsamir]

Thanks Ayman, But this cont puer hours between the two dates and doesn't execute weekends.

I need two execute Fridays Saturdays

[ayman_salem]

I have corrected the above formula: *2 --> *2*24 .

You just have to add 2 cases (2 other formulas).

Case 1: when "start date" is on the weekend

Case 2: when "end date" is on the weekend

(use DayNumberOfWeek)

the final formula: first formula + result case 1 + result case 2