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
|