picture format for time >24

[Robert Iliuta]

Hallo,


I need to calculate overtime per month and sometimes is over 24hours... how can I show in browse 33:00 ?
I try with picture format: @K##:##K but it will show me just 33 , the problems is that sometimes I have also minutes...
Is there some unsupported picture format in NT8 ?

Thank you,
Robert

[Bruce]

Hi Robert,

As you probably know the Clarion FORMAT command does not format times greater than 23:59.
In my own programs I've written a small procedure that formats the string for me, and then I just use a string format when displaying that on a window.

The @p or @k format should work (although I've not tested it, and there may be some issues) but I don't think they really help in this case. They don't convert the underlying number to "time". So, for example, if the time (long) value is 720001 (about 2am) and you format it with @K##:##K, you just get (at best) 72:00 which is useless.

That said, there's quite a lot of infrastructure around pictures already in nettalk, so I think overcoming the 23:59 limit would be do-able. I'll see what can be done.

cheers
Bruce

[Robert Iliuta]

Hallo Bruce,

Thank for reply.

The problem is that this app I develop is for maintenance and we have a lot of fields with time, calculation and totals of hour. The problem is when we have total of hours overtime per month and this sometime is over 23:59 hours ... there was situation with 44:00 hours... if there was only hours the I could make a long but they also have minutes... and this complicate things...
If you could do something in this case it will be great.

Thank you and appreciate your help.

Robert

[Bruce]

done in 8.12

cheers
Bruce

[Robert Iliuta]

Thank you Bruce!
Appreciate!
Robert