How to remove negative timevalues?
- From: torbein@xxxxxxxxx
- Date: 24 Jun 2005 05:10:02 -0700
I have a query where I calculate the elapsed time by subtracting Time
Out with Time In (24H time, no date in the timevalues). The problem is
that some of the Time Out-values are not available, thus the
calculation gives me a negative timevalue.
I need to replace the negative values with BLANK so that later
calculations of median time is correct. Any one who can help me with
this?
.
- Follow-Ups:
- RE: How to remove negative timevalues?
- From: Dennis
- Re: How to remove negative timevalues?
- From: Jeff Boyce
- RE: How to remove negative timevalues?
- Prev by Date: Error : Item not found in this collection
- Next by Date: Re: How to remove negative timevalues?
- Previous by thread: Error : Item not found in this collection
- Next by thread: Re: How to remove negative timevalues?
- Index(es):