hhhhhh:mm format data element

[Former Member]

Hi Experts,

I have to upload an excel file into program and update a Ztable. In the Excel file there is a column which is maintaining time in the format as follows:

d.hh:mm

317.22:15

i.e. 317 days 22 hours and 15 mins, if we add 3 hours to it then it will be 318.01:15.

I want a field to store this type of time format in the ztable.

So can u suggest me any data element which can solve my problem or any other solution.

Can I get a data element which can have hhhhhh:mm or hhhhhh:mm:ss format, so that i can store it using this format after calculating e.g. 317*24 = 7608; as 7608 + 22 = 7630; 007630:15 :: hhhhhh:mm.

[Former Member]

Hi Experts,

I have to upload an excel file into program and update a Ztable. In the Excel file there is a column which is maintaining time in the format as follows:

d.hh:mm

317.22:15

i.e. 317 days 22 hours and 15 mins, if we add 3 hours to it then it will be 318.01:15.

I want a field to store this type of time format in the ztable.

So can u suggest me any data element which can solve my problem or any other solution.

Can I get a data element which can have hhhhhh:mm or hhhhhh:mm:ss format, so that i can store it using this format after calculating e.g. 317*24 = 7608; as 7608 + 22 = 7630; 007630:15 :: hhhhhh:mm.

[Former Member]

Hi Abhi,

Your date time format does not contains year - check if You want to ignore it.

If You do not need year, than You can store it simply as INT4 type

and use conversion exit to change int to / from hhhhhh:mm:ss format.

Alternatively, You can convert it to date and time fields.

Regards,

--

Przemysław

[former_member282823]

Hi,

You can use the data element ANLVZ. or you can create your own data element with taking data type as TIMS which stores time as hhmmss.

Regards,

Ramesh.

[Former Member]

Hi,

To be more specific, You can also use Data element TIMESTAMP which is in Form (YYYYMMDDhhmmss) It's a UTC (Universal coordinated time) timestamp.

Regards,

Mukul