Total work hours for the seven days are not being added to the grand total box below.

Trying to learn JOTFORM online form builder. I tried to recalculate but messed up something somewhere!

1) I deleted the not needed "employees break column" from 4 to 3 columns in the matrix and now my total hours worked for the week are not being added to the TOTAL HOURS worked for the week in the box below.

2)  And, is there a widget available that calculates how many hours an employee worked for the day? (ie: hour clocked-in & hour clocked out would = total hours worked today? Instead of it being entered manually.

Thanks.

Bill

Hello Bill - Since you deleted some columns in the INPUT TABLE field, you need to re-do the formula in the TOTAL HOURS field. This is because the cell references have been changed when you deleted columns.

Regarding the calculation of time, you can use conditions for that.

Please do it to the other rows. It will automate the calculation of total worked hours for that day.

Here's my cloned form - https://form.jotform.com/200942718878972 

Hi JohnRex;

Thanks for your reply. 

The calculation of hours "clocked-in & clocked-out" I entered will only work for military hours entered but not for regular hours keyed in, (ex: clocked in=8, clocked out=1 display's -7, but should be 5).  

Everyday users don't know or even understand military hours being entered.  

The first row (Sunday) hours worked you calculated for me works fine for military hours entry but is there a calculation/formula that is available for inputting a 24 regular hours method for users? If not, then users have to learn this new way.

Thanks again

Bill

I await your reply. 

Unfortunately, it is not possible to use a time field in the Input Table field. So, it is required to use the number field. So, the difference is calculated as the number field only and cannot calculate as the time.

You may consider using separate time fields on the form and enable Time Range to calculate the difference automatically. 

Please give it a try and let us know if you need any further assistance. We will be happy to help.