Hellabelle
New Member
- Joined
- Sep 12, 2018
- Messages
- 1
Hi All,
Looking for some guidance on an excel formula to calculateworking hours for Monday to Thursday 08:30 – 17:00 and Friday 08:30 – 13:30. Theformula I’m currently using is below.
IF(OR([A2]="",[B2]=""),"",(NETWORKDAYS([@[A2]],[@[B2]])-1)*("17:00"-"8:30")+IF(NETWORKDAYS([@[B2]],[@[B2]]),MEDIAN(MOD([@[B2]],1),"17:00","8:30"),"17:00")-MEDIAN(NETWORKDAYS([@[A2]],[@[A2]])*MOD([@[A2]],1),"17:00","8:30"))
Any help would be appreciated!
Thank you in advance.
Looking for some guidance on an excel formula to calculateworking hours for Monday to Thursday 08:30 – 17:00 and Friday 08:30 – 13:30. Theformula I’m currently using is below.
IF(OR([A2]="",[B2]=""),"",(NETWORKDAYS([@[A2]],[@[B2]])-1)*("17:00"-"8:30")+IF(NETWORKDAYS([@[B2]],[@[B2]]),MEDIAN(MOD([@[B2]],1),"17:00","8:30"),"17:00")-MEDIAN(NETWORKDAYS([@[A2]],[@[A2]])*MOD([@[A2]],1),"17:00","8:30"))
Any help would be appreciated!
Thank you in advance.
