Hello and welcome to the forum.
E4:
Formula:
=IF(WEEKDAY(B4,2)<6,IF(AND(D4<C4,C4<0.75),0.75-C4,MAX(0,MIN(D4,0.75)-MAX(C4,0.25))),0)
F4:
Formula:=IF(WEEKDAY(B4,2)<6,D4-C4-E4+IF(D4<C4,1,0),0)
G4:
Formula:=IF(WEEKDAY(B4,2)=6,D4-C4+IF(D4<C4,1,0),0)
H4:
Formula:=IF(WEEKDAY(B4,2)=7,D4-C4+IF(D4<C4,1,0),0)
Then copy down.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
it works well thank you, except when there are no hours, then it comes up with 12 in F column and ######## in the G column
any ideas ?
sorry to be a pain, there is one more little problem,
if a shift starts at 23:00 and goes through to 08:00 in the morning, the 2 hours past 06:00 should show as 2 hrs of day shift- in the formula you gave it shows all as night hours.
there must be a simpler way of working this out , even if there are extra columns to help
Ok. I’m away for the weekend but will take a look on Sunday night.
Hi Richard, can you have a look at the problem when you can please
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks