Calculate number of hours using two field
Posted on 2014-04-16
I have a form which has two fields. They are "StartTime" and "StopTime".
In the bound table I have a calculated field named "ElapsedTime". I want to have that field populate with [StopTime] - [StartTime] in hours.
If StartTime for example is "4/16/2014 2:53:50 PM"
If StopTime for example is "4/16/2014 3:01:05 PM"
then the elapsed hours would be something like .13 right?
Anyway, how can I make the calculated field get the right result? I have it setup as Long Integer, Standard, 2 decimals but it isn't working correctly.