Avatar

Level 1

I've got a Form where I have a table with 8 fields and 1 field that calculates total hours worked. Each field the user needs to enter a valid time 8:00 AM or 1700, which will be converted to 5:00 PM. I'm trying to come up with a FormCalc formula that will give me the total hours worked.

This is what I have so far;

 

(Row5.Cell2-Row4.Cell2+Row7.Cell2-Row6.Cell2+Row9.Cell2-Row8.Cell2+Row11.Cell2-Row10.Cell2)*1440/60

The fields are as follows:

Start <Row4.Cell2>

Stop <Row5.Cell2>

Start <Row6.Cell2>

Lunch Start <Row7.Cell2>
Lunch End <Row8.Cell2>

Stop <Row9.Cell2>

Start <Row10.Cell2>

End <Row11.Cell2>

Total Hours

All it does is keep giving me weird totals and it's never consistant.