10

Hello buddy,

You’re very welcome.

You need another data field in that data type, call it Time of Exit and put it as a date field. Create a “Check Out” button, and then do "When this ‘Check Out’ button is clicked, make a change to thing > Visit > then do field Time of Exit = Current Date/Time. Copy the Repeating Group above (Employees Signed In) and paste it below and call it (Employee Signed Out) like you have in the screenshot. Now change “Time of Entry = Current Cells Checked In” to “Time of Exit = Current Cells Checked Out” in your current cell and change the column name to “Time of Exit” from “Time of Entry”.

You’re doing well though, so well done.

Regarding hours worked, when your user clicks the “Check Out” button and you make a change to Visit, add another field called “Hours Worked” and do “Hours Worked = Checked In - Checked Out: formatted as hours” and that’ll do what you want. Make sure to have the dash in between the Checked In and Checked Out. May have to switch those around if it shows as a minus. You can also just add a text box below “Hours Worked” in your repeating group and do “Current Cells’ Checked In - Current Cells’ Checked Out: formatted as hours” instead if you don’t want to save the hours worked in your database.

Hope that helps.