Code for automatically tracking time in clinic appointments on a Google Sheets document.
See example (view only): https://docs.google.com/spreadsheets/d/1wgs4391wcmzrWvFSggBL81YJSQmNaGzGfn3CxfeLH_0/edit?usp=sharing
Code.js is what you want to add to the Script Editor in Google Sheets.