Summary field based on Time of Day field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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?
Photo of Juan

Juan

  • 466 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,486 Points 50k badge 2x thumb
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.
Photo of Juan

Juan

  • 466 Points 250 badge 2x thumb
Thanks Mark, that's a good (albeit tedious) workaround to a simple want. I can't imagine why QuickBase wouldn't allow it.
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. =]