View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default create formula to add 15 minutes to previous time value

=A1+TIME(0,15,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bruce" wrote in message
...
I want to create an Excel formula that adds 15 minutes to the previous

time
value in a cell. For example, if cell a1 is 12:00:00 am, I want the next
calculated cell to become 12:15:00 am.
--
Bruce