Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]);
Like this
Max,
Correct me if i am wrong. He is asking about Subtraction.
Might be this
Time([In-Time] - 11/48, 'hh:mm')
You're right, he said subtraction
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
Thanks a lot Anil.
Please close this Thread if you resolve the issue. Please flag the Correct Answer who was the Correct
Time( [In-Time] - '05:30' , 'hh:mm')
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