Assuming that the start time is in A2, job time in B2, and they are both
formatted as time, just use
=ROUND((A2+B2)*96,0)/96
--
HTH
RP
(remove nothere from the email address if mailing direct)
"gibbylinks" wrote in message
...
I have two columns. One which calculates the length of time a job will
take
to run on a machine, and the other in which we put the time the job will
come
off the machine. At present we enter the time off manually. Is it possible
to
calculate the time off automatically (to the nearest 1/4 of an hour) if we
put in a start time ?
Thanks
|