=A1+TIME(16,0,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Martin B" wrote in message
...
I am trying to develop a spreadsheet to plan production batches and I
require is a formula which takes a start time, adds a number of hours and
displays the projected finish time. Foe example if a job is started at 21:00
on tuesday and takes 16 hours I need the sheet to display Wednesday 13:00.

Thanks for any assistance you are able to offer

Martin B