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"))))))))