topic Re: Need logic help related to time. in QlikView

Need logic help related to time.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In given data i want to subtract 5:30 hours from the In-Time and Out-Time both.

and for example time in/out time is 2:30 then output time should be 21:00 . and date should not be changed.

Please help me out asap.

Regards,

Lalit kumar

Re: Need logic help related to time.

maxgro — Wed, 27 Jul 2016 16:40:42 GMT

Directory;

LOAD [Employee Code],

[Employee Name],

Date,

[In-Time],

Time([In-Time] + 11/48, 'hh:mm') as [Out-Time]

FROM

[HR time.xlsx]

(ooxml, embedded labels, table is [HR time]);

Re: Need logic help related to time.

Anil_Babu_Samineni — Wed, 27 Jul 2016 16:43:39 GMT

Like this

Re: Need logic help related to time.

Anil_Babu_Samineni — Wed, 27 Jul 2016 16:47:42 GMT

Max,

Correct me if i am wrong. He is asking about Subtraction.

Might be this

Time([In-Time] - 11/48, 'hh:mm')

Re: Need logic help related to time.

maxgro — Wed, 27 Jul 2016 16:52:19 GMT

You're right, he said subtraction

Re: Need logic help related to time.

Anil_Babu_Samineni — Wed, 27 Jul 2016 16:54:50 GMT

If we write like

[In-Line] - '05:30' and then in number tab we just change that radio button to Time with the format of hh:mm

This is Correct? Because, i did same thing only with the below attachment

Re: Need logic help related to time.

lalitkgehlot89 — Wed, 27 Jul 2016 17:51:51 GMT

Thanks a lot Anil.

Re: Need logic help related to time.

Anil_Babu_Samineni — Thu, 28 Jul 2016 06:34:27 GMT

Please close this Thread if you resolve the issue. Please flag the Correct Answer who was the Correct

Re: Need logic help related to time.

tyagishaila — Thu, 28 Jul 2016 07:05:06 GMT

Time( [In-Time] - '05:30' , 'hh:mm')

Re: Need logic help related to time.

lalitkgehlot89 — Thu, 04 Aug 2016 07:20:11 GMT

Hi,

Here i am facing one issue.

When i am exporting data in excel it is coming in decimal format.

and exporting data in csv is ok.

Please suggest me what changes i have to do to get the exact data in excel.

Regards,

Lalit Kumar