Hi,
I need help in automating the delivery times for projects in the attached sheet.
If you see the Delivery Time column it should read 4:30 or fall within the boundaries of the in time and out time.
I need to automate the delivery time and delivery date columns.
I hope someone can help me or guide me to a usable template.
HI Sr2701,
welcome to the forum.
12:00 + 1:15+ 0:45 = 2:00 PM appears to be correct. How it should be 4:30?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
The 12 is the max time limit for the job.
This is working man hours. So limited by In Time and Out Time.
Okay... so how you got 4:30 ?
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks