How do I make a total time cuclation

If you put in the database in 12:00 and out 1:30 how do I cuclate 1 and 30 mins or 90 mins

Hi @GrantWoods ,
Subtract them and multiply with 1440 (24x60), then use modulo to get the fraction then multiply the fraction with 60.

Search old posts by Karimoo, you will find example there, my example above could be wrong, don’t remember the exact formula.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.