views:

459

answers:

0

I'm trying to create a timesheet that will calculate the hours an employee worked. There is 4 In columns and 4 Out columns that I need to total the hours (see below).

In 0830 Out 1200 In 1300 Out 1700 In ------ Out -----

Needs to total 7.5 hours worked

If I use (OUTA1[0]-INA1[0])/100+(OUTA1[1]-INA1[1])/100+(OUTA1[2]-INA1[2])/100 I get 7.7

If I use (OUTA1[0]-INA1[0])/100+(OUTA1[1]-INA1[1])/100+(OUTA1[2]-INA1[2])/100-.2 I get 7.5 but does not work when the hours are

In 0800 Out 1200 In 1300 Out 1700 In ------ Out -----

Any help would be greatly appreciated.