Skip to Content
0
Former Member
Apr 28, 2008 at 08:33 PM

Print a key figure duration fields in "HH:MI:SS"

6 Views

Hello,

I have a time key figure (duration) in hours (for exemple 0,25 hours).

I want to print it using the HH:MI:SS format (00:15:00 for 0,25 hours). How can I do it? I have seen the TIME function in the query designer but it cannot be bigger than 24:00:00.

I have thought about creating a badi to add a custom function but how to do it for the query functions? do you know an other solution? I would do that in the reporting side if it is possible...

Thanks a lot

Julien