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: 414
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: Riny van Eekelen, Lorna Henning
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28639
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —