Ask Your Question
0

Using Regular Expressions for filtering items in spreadsheet [closed]

asked 2014-12-18 10:58:00 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi there,

I have a spread sheet that consists of a time column with entries in the following format 15/11/14 17:56

I am interested in filtering items in the range of 12:00 to 18:00 for all the dates. Can anyone help me how to accomplish this using filters and regular expressions?

Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 02:28:52.099832

1 Answer

Sort by » oldest newest most voted
0

answered 2014-12-18 14:22:04 +0200

karolus gravatar image

updated 2014-12-18 14:27:37 +0200

Hallo

works here with Filterkriterium .+ (1[2-7]:[0-5][0-9])|(18:00):00$

and [x]regular Expression under →more Options

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-12-18 10:58:00 +0200

Seen: 1,491 times

Last updated: Dec 18 '14