How to create calculations in Input table?

  • Profile Image
    Asked 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.


  • Profile Image
    Answered 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.

    Thank you!

  • Profile Image
    Answered on September 11, 2017 at 07:43 AM
    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*
    *Harwinder *
    *Jagtar Traders*
  • Profile Image
    Answered 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: