Not Ready Time formula

[Thant]

Greetings,
I have a field called NotReadyTime(number) it lists time an operator was in not ready status for Symposuim call center. It stores the field as seconds(number) and I need to convert it to HH:mm:ss format. I saw the faq on this but was unable to replicate. Any help would be appreciated
Thanks

 

[fisheromacse]

Try this....it may have errors, i am typo-prone when not in front of crystal to test my math/syntax/etc. It should display as you wanted.


//{@NotReadyConv}
numbervar hh := (({NotReadyTime}/60)/60;
numbervar mm := (remainder(hh/60),60);
numbervar ss := (remainder((hh/60)/60,60));
(hh &":"& mm &":"& ss)

 

[Thant]

I had to add an extra ) to the formula so that the first half reads

//{@NotReadyConv}
numbervar hh := ({dAgentPerformanceStat.NotReadyTime}/60)/60;
numbervar mm := (remainder(hh/60))60);

It comes back and shows "The remaining text does not appear to be part of the formula

numbervar ss := (remainder((hh/60)/60,60));
(hh &":"& mm &":"& ss)

Any ideas?

 

[fisheromacse]

i had:
numbervar mm := (remainder(hh/60),60);

you had:
numbervar mm := (remainder(hh/60))60);

It should bee:
numbervar mm := (remainder((hh/60),60));

sorry about that.

 

[SkipVought]

Simply convert SECONDS to DAYS and FORMAT the result using the FORMAT function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Thant]

Skip,
Thanks for the idea and I would love to do this but ive never really used this function before could you give me a little bit more detail?
Thanks

 

[SkipVought]

First
Declare {yourdays} as a non integtral data type.

{yourdays} = sec / 60(sec/min) / 60(min/hr) / 24(hrs/days)

Then either

{yourdate} = CTime({yourdays})

or

{yourdatestring} = ToText({yourdays},"hr:mm:ss")

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Thant]

I think I understand the where its going but I as I said variables are kind of new to me. How would I use setup the declare?

Thanks and sorry for being clueless