Hello, I have made an app for personal use a...

(Stefaan EEMAN) #1

Hello,

I have made an app for personal use and I want to register my working hours. I’m paid as soon as I arrive at my first client and I’m paid until I leave my last client. the rest is driving time. But the driving time should be shown only in minutes, so 1(hour):20(min) driving means the app should show 80 minutes. How can I do that in Appsheet? than all the minuts of driving time above 80 should been added to work time (paid) can anyone help me? thx a lot

(Praveen Seshadri (AppSheet)) #2

To convert a duration into minutes, use the expression HOUR([DurationColumn]) * 60 + MINUTES([DurationColumn])