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

Posted by Eric on October 09, 2001 7:13 AM

Instead of 35, try 35/1440, =a16+35/1440 (NT)



Posted by stevenl on October 09, 2001 9:31 AM

Re: Instead of 35, try 35/1440, =a16+35/1440 (NT)

Worked.

Thanks.