Total hours slept column

Hey guys,

Beginner here. This is probably a stupid question, but I haven't been able to figure out the solution.

How can I add a column to a form so that my users can input the amount of time they slept?

My problem with time formulas is that use AM/PM

I hope that makes sense.

Thank you!

0 2 36
2 REPLIES 2

Hi,
You can use the "Duration" field type for this.
Then the user can input the duration in "hh: mm" format.

Aurelien
Google Developer Expert
Google Developer Expert

Hi @TPPGrey 

Here is a very nice answer from @Suvrutt_Gurjar :

Solved: Entry duration feature? - Google Cloud Community

(option mixing time and duration for user experience purpose is the best in my opinion)

and very nice key-points of understanding here from @Joseph_Seddik :

The notions of TIME and DURATION and how to use in... - Google Cloud Community

 

Top Labels in this Space