Time format cells - Addition Formula
Posted by stevenl on October 09, 2001 7:05 AM
I have a spreadsheet that contains outline indicating a sequential process. I want to indicate a value (format = Number/Time)in a "Start Time" column which allows me to basically say that the current task starts 35 minutes after a previous task's (reference cell) "Start Time" with what I was hoping can be a simple add formula e.g
=A16+35 where A16 has a "Time" format 7:00 A.M. and the desired result is 7:35 A.M.
Thanks