Log In
Register
Home
How to filter all below 5min 0s output from the time sheet dump
Prabu C
New Member
Members
Forum Posts: 1
Member Since:
February 24, 2020
February 24, 2020
Offline1
February 24, 2020 - 2:35 pm
Hi,
i want to filter out below 5min 0sec output from overall dump.
I checked some filter options but no luck to find out the solution.. can u help me.
Sample dump :
1min 1s
5min 0s
5min 0s
4min 59s
5min 2s
5min 1s
5min 3s
9min 59s
5min 1s
10min 1s
5min 59s
21min 0s
1hr 55min
9hr 24min
6hr 54min
4hr 1min
14min 59s
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 415
Member Since:
December 20, 2019
December 20, 2019
Offline2
February 25, 2020 - 7:22 am
Messy and with too many helper columns but seems to come out with the total minutes in column H, which can be filtered for less than 5.
I am sure others can come up with better
Let me know if it works
Purfleet
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 355
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
iDeYYtyNRPTss icXlxLtkCZaWuY
Elizabeth Kinsey
Shaun Del Toro
Clive Webb
Forum Stats:
Groups: 3
Forums: 25
Topics: 7095
Posts: 31110
Member Stats:
Guest Posters: 49
Members: 34529
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —