- JagtarTradersAsked on September 11, 2017 at 12:20 AM
I am looking to have the details from the employees of their everyday start time and finish time for both the shifts AM and PM and the hrs calculated for each shift and then also the total of the HRS from Mon to Sat in one place and for Sunday separate. Hope this is bit more clear.
- JotForm SupportNik_CAnswered on September 11, 2017 at 02:58 AM
This is how you have to create conditions to make it work:
So for each pair of AM In and Am Out, PM In and PM Out you have to create the above condition. That will calculate like this:
If you need any further assistance please let us know.
- JagtarTradersAnswered on September 11, 2017 at 07:43 AMHI
please see the link below
everything is pretty much ok except that i need to put the time in actual
time formate (ex 9:30 till 10:00 result .50hrs worked) and get it
calculated to hrs worked with the output in decimal format.
Please help me out
*Thanks and Regards*
- JotForm SupportamyAnswered on September 11, 2017 at 10:15 AM
While you are filling the time table would you please use dot "." instead of using colon ":"? By this way, the calculation functions can work properly. Please check my result: