Need logic help related to time.

[lalitkgehlot89]

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

[maxgro]

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]);

[Anil_Babu_Samineni]

Like this

[Anil_Babu_Samineni]

Max,

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

Might be this

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

[maxgro]

You're right, he said subtraction

[Anil_Babu_Samineni]

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

[lalitkgehlot89]

Thanks a lot Anil.

[Anil_Babu_Samineni]

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

[tyagishaila]

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

[lalitkgehlot89]

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