Re: determine time frame between to table entries
From: ChrisJ (anonymous_at_discussions.microsoft.com)
Date: 06/09/04
- Next message: Allen Browne: "Re: Add numbers 1-639"
- Previous message: Simon: "Re: Last Login"
- In reply to: patricia: "determine time frame between to table entries"
- Next in thread: Patricia: "Re: determine time frame between to table entries"
- Reply: Patricia: "Re: determine time frame between to table entries"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 18:35:45 -0700
Patricia,
an example.
Status Time Accum
Open 11:00
handled 11:01
resolved 11:02 00:01
handled 11:03
handled 11:04
handled 11:05
dispatched 11:06 00:04
handled 11:07
closed 11:08 00:05
Is this the sort of thing you need?
Do you need whole hours only or HH:MM:SS??
What if open/close is overnight??
Over a weekend??
Over a public holiday??
- Next message: Allen Browne: "Re: Add numbers 1-639"
- Previous message: Simon: "Re: Last Login"
- In reply to: patricia: "determine time frame between to table entries"
- Next in thread: Patricia: "Re: determine time frame between to table entries"
- Reply: Patricia: "Re: determine time frame between to table entries"
- Messages sorted by: [ date ] [ thread ]
