Duration field - for calculations

[skief-labs]

Hi there,
is there a simple way to add duration (time) as a actionable property? For instance, enter duration in hours:minutes:seconds and perform afterwards calculations such as average etc.

I know there is a “numerical” property but it’s not user friendly as one needs to transform hours and minutes in seconds.
Thank you all

[karimoo]

See: How to calculate with days and minutes

[skief-labs]

Thanks, I checked the resources provided. My use case is different a bit as it’s related to timed results (let’s say an individual participates in a bike race and wants to enter his time in h:m:s format). So far I created 3 fields, one per unit, not sure if it’s the best way to work. Ideally, I would create a calculated field (= hx3600+mx60+s) but it seems to be impossible for now.

[bibipac]

https://ideas.adalo.com/feature-requests/p/use-date-and-time-fields-in-formulas