I created a table that has a field name InTime and a field name OutTime with a calculated field name TotalTime. Now I need to create a calculated field name TotalUnits.

I need to convert the excel formula into a Access expression. I’m including the numbers of minutes that equal to a unit (if this helps).

Number of Minutes in Military Time Units

0.13 minutes through 0.37 minutes = 1 unit

0.38 minutes through 0.62 minutes = 2 units

0.63 minutes through 0.87 minutes = 3 units

0.88 minutes through 1.07 minutes = 4 units

1.08 minutes through 1.37 minutes = 5 units

1.38 minutes through 1.62 minutes = 6 units

1.63 minutes through 1.87 minutes = 7 units

1.88 minutes through 2.13 minutes = 8 units

This is the excel formual:

=IF(I8>1.88,"8",IF(I8>1.63,"7",IF(I8>1.38,"6",IF(I 8>1.13,"5",IF(I8>0.88,"4",IF(I8>0.63,"3",IF(I8>0.3 8,"2",IF(I8>0.12,"1","0"))))))))