Kbase P135226: How do I display an integer seconds field in EasyAsk in HH:MM:SS format?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/09/2008 |
|
Status: Unverified
GOAL:
How do I display an integer seconds field in EasyAsk in HH:MM:SS format?
GOAL:
How do I display an average of an integer seconds field in EasyAsk in HH:MM:SS format?
GOAL:
How do I ask questions about average time when my data is stored in seconds and I want to display the answer in HH:MM:SS format in EasyAsk?
FACT(s) (Environment):
EasyAsk 11.0
EasyAsk 9.7
FIX:
Create fields or name your columns "hold time in seconds", "queue time in seconds", etc.
Then define formulas "hold time", "queue time", etc. in which the time is represented in days. The definition of "hold time", for example, will be:
Hold time in seconds / 86400 (where there are 86,400 seconds in a day)
For each of these formulas, change the Display property to hh:mm:ss
(HH:MM:SS will not appear in the drop down list, it must be manually added)
Then (as in Excel) EasyAsk will display these fractions of days in the desired format. You should be able to ask questions about average hold time, average queue time, etc. as well and have them work correctly, since EasyAsk will average these fractions and display the average in this format.