Hello everyone !
I have a list in SharePoint which contain EmployeeName, CheckInTime, CheckOutTime, Status, Total Worked Hours columns.
The employees will use the mobile flow apps.
When the employee check-in it will create a new item in the list showing the current Date include time,and on check-out it will modify the item, update the status to check-out, and it will update the CheckOutTime to current date include time.
When the users checkedout, the flow should trigger the user he checkedout and calculate the total worked hours between the 2 different columns (CheckInTime & CheckOutTime) and update the column showing the total of hours he worked for.
Example:
Suppose that the user CheckedIn at 8:04 and Checkedout at 9:04. It should show 1 HOUR text and maybe he checked for couple of minutes is it possible to show 30 Minutes.
Here is my list:
Here is the flow:
What i should add to the flow to achieve it and what are the expressions i should use ?
Can you please provide an example ?
Thank you!!
