Filter problems

drag-driver · Feb 22nd, 2002, 03:36 AM

Want to filter a series of times eliminating the times less than 02:00. I did this using custom filter, and it work when i calculate the times one way and does not work when i calculate the times another. I require the time to be calculated the second way.the two formulas are "B3-B2",and the 2nd one is b3+ (23:59 - B2).Where b3and b2 are times.

George J · Feb 22nd, 2002, 04:11 AM

Not sure if this is what you are looking for.

=B3+(1-B2)

This is B3(say 07:00)
+ 1 day - B2(say 03:00)
This gives 28hrs

Can you give more details if you are looking for something different?

Feb 22nd, 2002, 04:11 AM	#2
George J Board Regular Join Date: Feb 2002 Location: Edinburgh, Bonnie Scotland Posts: 820	Not sure if this is what you are looking for. =B3+(1-B2) This is B3(say 07:00) + 1 day - B2(say 03:00) This gives 28hrs Can you give more details if you are looking for something different? __________________ George J

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 03:36 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	Want to filter a series of times eliminating the times less than 02:00. I did this using custom filter, and it work when i calculate the times one way and does not work when i calculate the times another. I require the time to be calculated the second way.the two formulas are "B3-B2",and the 2nd one is b3+ (23:59 - B2).Where b3and b2 are times.