+ Reply to Thread
Results 1 to 11 of 11

I want a code that can count the no. of rows covered in an hour using the timestamps

  1. 01-06-2022, 02:45 AM #1
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    I want a code that can count the no. of rows covered in an hour using the timestamps

    11111111111
    Last edited by John521520; 01-07-2022 at 05:45 AM.
    Reply With QuoteRegister To Reply
  2. 01-06-2022, 03:10 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,870

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    One option is to use Power Query
    Please Login or Register  to view this content.
    Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

    It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

    - Follow this link to learn how to install Power Query in Excel 2010 / 2013.

    - Follow this link for an introduction to Power Query functionality.

    - Follow this link for a video which demonstrates how to use Power Query code provided.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 01-06-2022, 03:28 AM #3
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Maybe, in I3 then drag down:

    Please Login or Register  to view this content.
    Quang PT
    Reply With QuoteRegister To Reply
  4. 01-06-2022, 03:55 AM #4
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Hi,

    this should work automatically.
    As timestamps are added in F, it should automatically update in column I.
    Last edited by John521520; 01-06-2022 at 03:57 AM.
    Reply With QuoteRegister To Reply
  5. 01-06-2022, 04:01 AM #5
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Hi,

    This should work automatically.
    When timestamps are added in the Column F, it should be automatically updating in column I live.

    Thank you
    Reply With QuoteRegister To Reply
  6. 01-06-2022, 04:02 AM #6
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,870

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    In PQ, when you update the source data and click on Refresh All, it will automatically update the results.
    Reply With QuoteRegister To Reply
  7. 01-06-2022, 04:04 AM #7
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Hi, I does not know any thing about VBA coding. I also does not know how to use this code.
    Please make a working file of Excel (putting this code into it).

    Thank you
    Reply With QuoteRegister To Reply
  8. 01-06-2022, 04:19 AM #8
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Thank you i got it. it is working.

    But i want that it should refresh on its own whenever a new entry is added.

    or you can add an auto refresher with time interval of 1 second.
    Reply With QuoteRegister To Reply
  9. 01-06-2022, 05:28 AM #9
    John521520
    John521520 is offline
    Registered User
    Join Date
    01-03-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    24

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    i want that it should refresh on its own whenever a new entry is added.

    or Please add an auto refresher with time interval of 1 second.

    Please
    Reply With QuoteRegister To Reply
  10. 01-06-2022, 06:35 PM #10
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,870

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    Have you read my posts? I explain that it refreshes and I provided you with a sample file. In addition, I explained how to use the code. Did you not see my post? Did you not understand it?
    Reply With QuoteRegister To Reply
  11. 01-06-2022, 09:16 PM #11
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: I want a code that can count the no. of rows covered in an hour using the timestamps

    With my formula in #3, try to extend the range from F144 to, i.e, F1000
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Timestamps for Multiple Columns. Need to Modify the Code
    By bssol in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-11-2022, 03:06 AM
  2. [SOLVED] Power Query - Pivot Table not able to group timestamps into hour/days/months/years
    By dcwan in forum Office 365
    Replies: 6
    Last Post: 08-24-2020, 12:34 PM
  3. [SOLVED] Power Pivot - grouping timestamps by hour is not in incremental order
    By dcwan in forum Office 365
    Replies: 8
    Last Post: 08-17-2020, 06:05 PM
  4. [SOLVED] How to count # of days between 2 timestamps
    By JaneMRO in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2020, 06:24 AM
  5. [SOLVED] Count number of revenue months until cost is covered
    By macrorookie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-05-2020, 04:47 PM
  6. Automatically delete rows between timestamps
    By Ptansley in forum Excel General
    Replies: 11
    Last Post: 08-06-2019, 08:13 AM
  7. count no of due days covered between 2 dates
    By Ganesh A in forum Excel General
    Replies: 4
    Last Post: 12-30-2007, 08:04 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1