Yes, that is true. So instead of automating the process of going from Duration 2 field to Duration 1 field, you could manually do the process to add that extra step of “human authorization and human approval”. Add that human element into it.
Otherwise, it sounds like you’d really like to have a custom interface with custom restrictions for your employees when using your system, which isn’t really possible in Airtable. Think of Airtable as a spreadsheet with some extra database functions built into it.
I would also think about using a different platform altogether — a platform that is a dedicated time tracking platform, for example — and do all of your time tracking there. Then, you could automate the process of bringing in the totals from there into Airtable. Your employees could use that other platform, and then that platform would send the data into Airtable.
Also, a full-blown custom app creation platform like FileMaker (which is my other expertise) can be used to create a custom time tracking app for you on both mobile and desktop, and then you could use Airtable’s API to have your custom FileMaker app communicate natively back-and-forth with Airtable. Two-way, real-time, instant communication between FileMaker and Airtable is a great way to have the 2 platforms communicate with one another.
If you need my personal help with any of these options, feel free to send me a private message.
Hope this helps! If one of my posts answers your question, could you please mark one of my comments as the solution to your question? This will help other people who have a similar question.