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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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.

     

    Joe

     

     

     

    Saturday, April 9, 2011 2:20 AM

Answers