I have a formula in a cell that calculates times.
=WORKDAY($R3,INT(E3/$G$1)+1)
Column R3 is the start date.
E3 is number of hours a job takes to run
G1 is number of hours available
The formula is supposed to take the start date, add the number of hours a job is to run, divide it by the number of hours available to run and come up with a end date.
It used to work, however, now it is making all end dates the next day at 12:00 am.
Help
Bookmarks