You can make a Duration field
[my time of day field] - ToTimeOf Day("12:00 am")
I'm assuming that you can do a summary Maximum on that. Then if you need to convert that back to a time of day field you could make a new field
ToTimestamp(Today(), ToTimeOfDay("12:00 am")) + [My summary Max duration field]
- ToTimestamp(Today(), ToTimeOfDay("12:00 am"))
I don't think you are allowed to add duration to a time of day field. It's a vague memory but I did not have time to test.
.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------