Skip to main content
Question

Summary field based on Time of Day field

  • May 3, 2017
  • 0 replies
  • 100 views
Is there no way to do a summary field based on Time of Day fields?

In an existing relationship, I want to create 2 summary fields in the Parent table:

Min of Start Time
Max of End Time

However, the Start Time and End Time fields don't even come up for me to select in the "for the field" dropdown:


Thoughts?
      This topic has been closed for replies.

      Hmmm, I tested and you are correct.  

      I suppose that if you really need this you can make a formula field to turn this into a field that will summarize, such as the number of minutes from midnight, then Summarize that field, and then have another formula on the Parent to convert those minutes back to a Time of Day field.
      • EricJHansen
      • Quickbase Alumni
      • May 4, 2017
      You CAN do a min or max summary of a date/time field. That might be the solve here. 

      Create a formula date/time field for start date and start time. The formula would be: totimestamp([start date], [start time]) and call it Start Date/Time. Then summarize that value up to your parent record. Just a thought. =]
      Terms & ConditionsAccessibility statement