How to calculate total hour and minutes within time range RRS feed

  • Question

  • User-313791273 posted

    I need to prepare a yearly management report to show the total overtime (OT) work hours and minutes of all staff within time range and month.


    The time format in database is as follows:

    Each record will contains the FROM date & time and TO date & time


    The report layout is as follows:



    I had no idea how to divide and calculate the total hours & minutes within the time range as each OT records will overlap several time range and date.

    Please help. Thanks.






    Saturday, April 9, 2011 2:20 AM