Closed Thread
Results 1 to 2 of 2

How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06

  1. #1
    Registered User
    Join Date
    01-09-2021
    Location
    California
    MS-Off Ver
    Google Sheets
    Posts
    4

    How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06

    Google Sheets: How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06 07:59)
    This is for Google Sheets, but I expect that there is something equivalent in Excel, so any help answering this would be appreciated!

    I'm trying to filter data to include rows that only have timestamps within certain date & time ranges. For example, I want to see a 24hr time window from 8am to 7:59am the next day; and another time window for a week from 8am Monday to 7:59am the next Monday.

    So far I have a working formula that lets me match for within the same date:
    =Filter(IMPORTcsv!A2:H, regexmatch(IMPORTcsv!F2:F, "t 2020-12-14"))

    How do I adapt this for more granular time range filtering?

    Thanks,
    RDDT

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-0

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue in the original thread
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Call in the Cavalry - 2021
    By AliGW in forum The Water Cooler
    Replies: 59
    Last Post: 01-07-2022, 12:58 PM
  2. How to use Regexmatch to filter ranges of Times & Dates (ie, 2021-01-05 08:00 - 2021-01-06
    By rddt in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 9
    Last Post: 01-10-2021, 05:01 PM
  3. Hilfe - Chef will Umsatzprognose 2021 von Subunternehmer
    By Des Nicolchen in forum Non English Excel
    Replies: 0
    Last Post: 01-09-2021, 09:32 AM
  4. Hilfe - Chef will Umsatzprognose 2021 von Subunternehmer
    By Des Nicolchen in forum Excel General
    Replies: 0
    Last Post: 01-09-2021, 09:32 AM
  5. Hello 2021
    By clixkers in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-09-2021, 03:25 AM
  6. [SOLVED] Formulating 1/1/2021-1/2/2021, 1/3/2021-1/9/2021 etc through one row.
    By jbposey86 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-24-2020, 08:27 PM
  7. Formula for Wednesdays & Sundays in 2021
    By Stev3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2020, 09:12 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