+ Reply to Thread
Results 1 to 3 of 3

Counting minutes

  1. #1
    Registered User
    Join Date
    06-04-2006
    Location
    Cheshire, UK
    Posts
    47

    Counting minutes

    A$1 = 1535 (ie the time 15:35). I can't change the format.

    To add 1-minute increments in successive rows in the same column, I use:

    A2=A$1+1
    A3=A2+1
    A4=A3+1
    etc.

    The problem is when I get beyond 1559 - it continues 1560, 1561, etc. How can this be solved?

    Thank you.

    Grant.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    If you just want to display as 1535 then I suggest you put 15:35 in A1 and then in A2 copied down

    =A1+"0:01"

    format the whole column as hhmm

    If you really want A1 to remain 1535 (general format) then try this formula in A2 copied down

    =TEXT(TEXT(A1,"00\:00")+"0:01","hhmm")+0

  3. #3
    Registered User
    Join Date
    06-04-2006
    Location
    Cheshire, UK
    Posts
    47
    Daddylonglegs,

    I can't determine the data, eg the time. Similarly, the format (although I could change this if I knew what I was doing). Also, the time also serves as a reference in a =VLOOKUP() table.

    Your second solution works fine. Thank you, really appreciated.

    Grant.

+ 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