Return to FileMaker.com
Time in minutes
Using FMP 10
I have two time fields. I want a third calculated field that shows the difference in minutes EVEN WHEN THE TIME DIFFERENCE IS GREATER THAN AN HOUR. i.e. 1hr 17min would show as "77"
Specifically (I'm a newby) how do I do this.
Create a calculation ( result is number ):
Case (TimeIn and TimeOut ; // both time fields have a value before it will evaluateDiv ( TimeOut -TimeIn ; 60 ))
This is assuming you want to drop seconds entirely. :-)
Retrieving data ...