Calculating Time difference between Auto Generated Date/Time and Manually Entered Time column
I currently have a form that collects a small sample of data and then generates a row on a sheet, and that row has a "created" column using the auto generated date/time stamp.
Someone completes that task and then marks the row "Approved" which generates an approval DATE and then they manually enter a time stamp using the 24HR format (HH:MM).
How can I calculate the time it takes from creation to approval?
Any help would be appreciated!
Help Article Resources
Check out the Formula Handbook template!