If i create a form asking people to insert the time of their working time, can i insert a formula into the deft form? For example, if the customer insert his working time is from 10.00-12.00, deft form can automatically calculate that his working hours = 2 hours.
Other examples (input from people from the deftform):
Name Working time
John 9.00-10.00
James 10.00-12.00
Susan 12.00-16.00

Can i insert a formula to calculate the number of hours for each person and total number of hours.

Output in database (google sheet):
Name Working time Hours
John 9.00-10.00 1 hour
James 10.00-12.00 2 hours
Susan 12.00-16.00 4 hours
TOTAL HOURS 7 hours