How to formulate survey cost in appsheet

MTurner1 · 08-31-2020 04:26 PM

Hi,

How do I formulate the price of a survey based on time within my app?
I wish to calculate a price based on time e.g. $1 per minute and have this calculate automatically at the end of my app sheet form.

Thank you in advance.

Marc_Dillon

Record a start time in a column. Record an end time in a column. Subtract. (HOUR() * 60 + MINUTE()) * $1

MTurner1

Thank you! I ended up using MINUTE([Duration]) * 1 with the field of price, and that worked.
Thank you for steering me in the right direction, I appreciate it.

Aleksi

Please use TOTALMINUTES() instead of MINUTE() because it will give you a correct answer when the duration is more than 60 minutes.