Display the time in a different format

[former_member723329]

Hey Guys,

I have an ALV where i output some time fields from cr02. Now it looks like this: 19.800 but i need it like this: 00:00:00

How can i do it on a very easy way?

Kind regards

Mario

[FredericGirod]

You will need to provide part of your code, especialy the field catalog

[former_member723329]

Hello

This is my type structure.

the data type is tims.

I select this fields from the table into the fields of my table.

Now i want to change this fields, so that they look like format 00:00:00

[Sandra_Rossi]

In the catalog, uUse the type D for dates (or DATS), not a numeric type like I, P, etc. (or INT4, DEC, etc.) Or indicate a field or a data element which refers to such a type.

[Sandra_Rossi]

And how does your field catalog look like?

[former_member723329]

Hello Sandra Rossi,

I output the alv like this. alv.png

so i think the output is like the fields from my types

[FredericGirod]

But it is not a time, it is a number of second.

you have to play with it before display it:

could be something like that (I don't test the code)

data(hour) = time DIV 3600.
data(remaining_time) = time - (hour * 3600 ).
data(minut) = remaining_time div 60.
data(second) = remaining_time - ( minut * 60 ).
result = |{ hour }{ minut }{ second }|.

[former_member723329]

thank you i will try it this way

[Sandra_Rossi]

You'd better avoid indicating the important part of the question in a separate image. The 3 fields concerned are:

• KAKO-BEGZT (Start time in seconds (internal))
• KAKO-ENDZT (Finish time in seconds (internal))
• KAKO-PAUSE (Cumulative break time in seconds (internal))

19,800 means 19800 seconds = 5 hours and a half

[RaymondGiuseppi]

Did you try to define some fields with a TIMS / T data type. With implicit conversion adding your integer fields in seconds to an initial time field will provide the expected result (just check for overflow)

[former_member723329]

ty sandra.rossi