Hi,
I have been trying to get this to work for awhile but not luck.
I am developing a Go Live runsheet that lists each task, its duration, start time, finish time and dependencies.
I want to build in some logic that says if a task is due to start after, say 5:00pm, then it reschedules for 9am the next business day. I have been trying to use the TIME function but to no avail.
Any assistance is greatly appreciated.
Regards,
Brad
Something like this should work
Formula:
Please Login or Register to view this content.
see attached file to see how it looks
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or ...
=IF(MOD(A2,1)>=17/24,INT(A2)+1+9/24,A2)
Thank you for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks