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