I have an employee time log database where each employee signs in with a timestamp date field (they can adjust it if they need to). Then they log out, and an additional field calculates their hours: DATETIME_DIFF({Time out}, {Time in}, ‘minutes’)/60
...
I am looking for the correct formula for the following:
[Field] Time off End - [Field] Time off Start = [Field] number of days
i.e. 11/15/17 - 11/18/17 = 4
I realize the result of the calculation might be 3, since the 18th is not included, but I shou...
I have a Time Log database that I have created for a small business. Users log in, choose their name from another table, and do a “time in”, which provides the current data / time. Users are allowed to change the start time (in the event that they fo...
The single quotes issue has been addressed, however there is still a problem.
In my original field, I simply used “Date” for the field type, It put in the current date / time, but then the user had the option to modify it, which is what I want.
This ...
