Forum Discussion

AdminEntry's avatar
AdminEntry
Qrew Cadet
8 years ago

Summary field based on Time of Day field

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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
    • AdminEntry's avatar
      AdminEntry
      Qrew Cadet
      8 years ago
      Thanks Mark, that's a good (albeit tedious) workaround to a simple want. I can't imagine why QuickBase wouldn't allow it.
  • Eric_J_Hansen's avatar
    Eric_J_Hansen
    Qrew Cadet
    8 years ago
    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. =]