I have a form with
TimeIN (short time)
TimeOUT (short time)
Elapsed Time ---> calculated field that is giving me trouble!!
I thought I could use the DateDiff function:
DateDiff ('h', [TimeIN], [TimeOUT])
But it's not working...
For example if somebody entered the following
TimeIN: 1:15 AM
TimeOUT: 2:00 AM
Elapsed time should equal 00:45
How can I get this to work??
Thanks!
TimeIN (short time)
TimeOUT (short time)
Elapsed Time ---> calculated field that is giving me trouble!!
I thought I could use the DateDiff function:
DateDiff ('h', [TimeIN], [TimeOUT])
But it's not working...
For example if somebody entered the following
TimeIN: 1:15 AM
TimeOUT: 2:00 AM
Elapsed time should equal 00:45
How can I get this to work??
Thanks!