How can I enter minutes in a form?
I'm 2 weeks into QuickBase and am totally stuck!!! I have a form that has a "Start Time" (Time of Day) and "End Time (Time of Day), but I need to manually enter a minute value for a field. My field...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI suggest changing the field type for [Stationary Time in Minutes] to plain numeric and renaming it to clarify the units expected (ie the user should enter minutes.
Then your formula would be
[Time End] - [Time Began] - Minutes([Time Stationary in Minutes])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Then your formula would be
[Time End] - [Time Began] - Minutes([Time Stationary in Minutes])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
I got this one to work ([Time End] - [Time Began]) - Duration
------------------------------
William Wallace
------------------------------
------------------------------
William Wallace
------------------------------
- MarkShnier__YouYes that works too as long as one staff know to enter the minutes. I think they would have to enter like 30 min
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------