I have a form that logs work times. Start time, end time, to calculate hrs worked. What I would like to do is enter Break times into a field, say 00:30 minutes without having to pick the break start time and break end time. If I make the field time it pops up the time picker. If I make it text with the time format, or if I make it a pick list it doesn’t work. Is this possible?
You could use a Number field, but then you’d have to enter 1800 into the field for your break time. Then add this field to your calculation. 1800 is the number of seconds in 30 minutes. All time calculations are based on seconds. You could use a numerical pick list to quickly enter different numbers of seconds. E.g. 1800 for 30 seconds, 3600 for 1 hour, etc.