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: 412
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: Lynnette Altomari, Jessica Stewart, Roy Lutke, Jeff Krueger
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Sopi Yuniarti
sandra parker
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Forum Stats:
Groups: 3
Forums: 24
Topics: 6214
Posts: 27243
Member Stats:
Guest Posters: 49
Members: 31894
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —