Hi, I would you like ask to for help with my succsess. Night work start from 22:00 (10:00PM) end ending at 06:00 (06:00AM). I prepare one formula whicht calculated corectli day and night shifts but i cant implement to the macro.
Formula to day working horus is :
"=MAX(;MIN($J$1;IF(C2<B2;1;0)+C2-E2)-MAX(B2;$I$1))+IF(AND(C2>$I$1;B2>C2);C2-$I$1;0)"
how I can translate it to the VBA code or how i create in VBA formulas for paste this functions to .cells(y,1)?
thank you for help
Make a recording and check what vba creates then alter to make it automatic
you get (sort off)
or
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Joske920; 10-28-2021 at 06:41 AM.
Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
If you have been helped, maybe you could click the *
Thank you very much, its working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks