I built a base to track my medicine but need a time field type to improve it. Any chance that could be developed? You probably want to build in standard time where user can designate their time zone and what is known as military time.
Also make sure you correct the quotes used when copying the formula. The forum appears to mess them up at times, turning some straight quotes into curly quotes. Straight quotes work for formulas; curly quotes don’t.
I wouldn’t assume that they’re not listening. Prioritizing software updates is a lot more complicated than many would assume, and there’s a lot that we don’t know about what’s happening behind the scenes. From what I’ve seen elsewhere, it helps the folks at Airtable to get details about specific use cases where Feature X could potentially be used. If you could describe how you would specifically use (and benefit from) something like this, it would carry a lot more weight.
Here’s my use case for the need for a separate time field. I need to be able to calculate the total and subtotal of time duration across sets of records and cannot for the life of me figure out how to do this. While I can get a Min Date and Max Date in summary fields, I can’t get a Min Time or Max Time to show up in subtotal or total fields, nor can I use or create them in a Pivot Table. Help!!
Hi @Peter_Nelson2 and welcome to our community! :slightly_smiling_face:
Just curious whether a combination of Date (without a time field) and Duration field types would be suitable (or at least a work-around) for your use case…?
You can use a formula like {End Time} - {Start time} to compare durations.
