+ Reply to Thread
Results 1 to 8 of 8

time line adding a specific time frame in each additional cell

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    North Queensland Australia
    MS-Off Ver
    Excel 2007
    Posts
    44

    time line adding a specific time frame in each additional cell

    Hi There,
    Rather than manually typing the time in 5 min increments across a range of cells, i want to have a start time, then the next cell add 5 mins.
    EG: 09:00 next cell 09:05 and so on.

    Thanks for the help

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,549

    Re: time line adding a specific time frame in each additional cell

    If you have 09:00 in Cell "A1" Then A2 = A1+5/1440

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,843

    Re: time line adding a specific time frame in each additional cell

    With 09:00 in A1, 09:05 in the next, select both cells and drag across or down
    Ben Van Johnson

  4. #4
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: time line adding a specific time frame in each additional cell

    In A1 manually type 09:00

    in A2
    =A1+5/24/60

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  5. #5
    Registered User
    Join Date
    11-02-2013
    Location
    North Queensland Australia
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: time line adding a specific time frame in each additional cell

    Thank you for the rapid replies.
    Have done it before but could not remember how.

    Enjoy your day.

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: time line adding a specific time frame in each additional cell

    Another way around without formula.....

    Like fill A1=9:00 and B1=9:05 and now select A1:B1 and drag the fill handle across (to C1,D1,E1....so on) as far as you need.

    Does this help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  7. #7
    Registered User
    Join Date
    11-02-2013
    Location
    North Queensland Australia
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: time line adding a specific time frame in each additional cell

    Thanks sktneer,
    yes it does help.

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: time line adding a specific time frame in each additional cell

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum number of calls within a specific time frame
    By t83357 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2013, 11:38 PM
  2. [SOLVED] Assigning a category to a specific time frame
    By Woofaloo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2013, 07:15 PM
  3. Excel 2007 : Adds values for a specific time frame
    By Raist23 in forum Excel General
    Replies: 3
    Last Post: 03-15-2012, 05:43 AM
  4. formula to show average over specific time frame over multiple sheets
    By bademployee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2010, 08:22 PM
  5. [SOLVED] Number of tasks completed in a specific time frame
    By Robert in forum Excel General
    Replies: 2
    Last Post: 02-03-2006, 09:30 AM

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