posted on May 15, 2019
I have a time field in the form with format: "HH:mm:ss"
I created a number field named "TIMEVALUE" with the calculation:
=TIMEVALUE(tbl_timecard.Time_In)
Where the value is set to have 4 decimal places for accuracy.
I created another number field "Total Time" with the calculation:
=tbl_timecard.Time_In * 24.0000
this field is also set to 4 decimal places for accuracy.
I have found the first two fields work fine. I choose a date and the "TIMEVALUE" field populates the fraction value correct.
The last number field calculation however is not working.
It should simply be taking "0.1250" * 24.0000
Any thoughts on why this calculation is not returned? Thanks!
1
0