Trouble quoting date+time(hour/mins) of project start date/completion using the WORKDAY function.
Hello, I'm currently tasked with completing an excel document that accurately quotes job start and completion dates (including time of day within a work shift). So far I've been able to come up with a system that works for the most part but I'm having some issues relating to the WORKDAY function. My goal is to have an input start date/time (ex. Wednesday July 10, 2019 7:00 AM) which in turn will generate accurate information of the completion date/time for the job and simultaneously calculating when the next job will start/finish (start date/time is the finish date/time of the previous job). Ex: Start: Wednesday July 10, 2019 7:00 AM - Finish: Thursday July 11, 2019 2:55 PM. Start: Thursday July 11, 2019 2:55 PM - Finish: Friday July 12, 2019 9:45 AM. So far I've been able to calculate the finish "date" but I'm having troubles with the information generating the "time" of completion and therefore the next jobs start date/time (specifically time) correctly. The system seems to be generating the "day of completion" fine but the "hours/mins" are not calculated into the equation. I would like the WORKDAY function to be set to 7:00am - 3:30pm but I'm not sure if this is possible. The document is referring to a chart which calculates the approximate time it takes to complete a specific job depending on the amount of "parts"and "blades". (ex: (#of parts * #of blades) * Time Per Blade = Total time (0.0 days) .) The total time is then used in the workday calculation: WORKDAY(start_date, Total Time, no holidays). I'm not sure if I'm using the WORKDAY function incorrectly or not. The end goal is to have it calculate the date and time of day when a job will be competed, then in turn generating the next jobs start time. Attached is the document for better clarity. Any help would be appreciated. I'm fairly new to excel so spare me the criticism if this is a common error. Thanks!