+ Reply to Thread
Results 1 to 2 of 2

create formula to add 15 minutes to previous time value

  1. #1
    Bruce
    Guest

    create formula to add 15 minutes to previous time value

    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

  2. #2
    Bob Phillips
    Guest

    Re: 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" <[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




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1