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
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
=A1+TIME(0,15,0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Bruce" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks