Forum Discussion

WilliamWallace's avatar
WilliamWallace
Qrew Member
3 years ago

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

3 Replies

  • 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
    ------------------------------
    • WilliamWallace's avatar
      WilliamWallace
      Qrew Member
      I got this one to work ([Time End] - [Time Began]) - Duration

      ------------------------------
      William Wallace
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        Yes 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
        ------------------------------