How can I enter minutes in a form?

Question

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 "Stationary Time" is set (Time of Day) for the default, but if I enter 30 minutes, the field displays 12:30am. I only want it to display :30 and be able to calculate (Time End - Time Began - Time Stationary = Total Time).

Any help would be appreciated.

------------------------------
William Wallace
------------------------------

MarkShnierYou · Answer

I 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
------------------------------

Sign up

Login to the community