Calculate total hours in tables

On the link you'll see 2 tabs (Weekly Timesheet & Employee Directory) - I am currently referring to the Weekly Timesheet tab.

So, I need assistance in the Total Hours column:

This column will calculate the total hours worked Monday to Sunday (we usually only work Monday to Friday, but we sometimes work on weekends when things need to get done). Currently this column only counts the hours and not the hours and minutes.

Kindly allow me some time to check your tables. I will be back shortly.

Thanks for patiently waiting. Looks like the table can't calculate the hours + minutes through the formula. I suggest calculating the total in the form itself. Take a look at this form:

Would it work for you? I got the total by adding the time fields in the widget.

1. You can enable the Time Range option on the Time field, here is where to find it:
   
   
2. If you use the time range option the calculation will already count the hours between the time range, here is a clear example:
   
   
   As you can see the first time field will return the number of hours between both hours. So in other words you will need to modify your form and instead of using two time fields you should use only one.

I would recommend to kindly modify your form according to the example and give it a try, let us know if you have any questions.

Greetings,

I've checked your form and found no issues with the calculations and it's set properly, in fact I recalculated your inputs as in the screenshot and found the total is 39h 27m which is 39.45 when converted to decimal number.

Please let us know if you need further assistance we are happy to help.

I've been following this thread, however, the Time Element you've suggested seems different than what is available for me. In your example, the user inputs the time like a text box, however when I add this element to the form, the only option for the time is a Drop-down for Hour/Min.

Am I using the wrong Element?

I checked your form and it seems you haven't enabled TIME yet on your date picker field. Please turn it ON so you input time in a textbox

In case I misunderstood your query, kindly share some screenshots for us to see what it looks like from your end.

Guide: How-to-Post-Screenshots-to-Our-Support-Forum

Thank you. There was a misunderstanding. The screen shots from the thread above indicate the Time Element is being used, and not the Date Picker Element. However, when I use the Time Element, the only options I see available is the Drop-Down

Hi there,

Sorry for the misunderstanding about the element being used.
You can remove and add the Time Element in your form and see if that will resolve the issue with the drop-down options to select the time. We have cleared your form's caches in case that is causing some issues with the form. If you have still issues with the Time Element and its properties provide us with more details and information so we can further assist you.

Thank you.