• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

calculation of time remaining and time difference

Hi Team,

need help on these please;

i need a formula wherein it would reflect the unaccounted/not yet rendered OT hrs within a day's shift to reflect in column I everytime i changed the time stamp in cell H2 (10:00 pm)

conditions:
- in below screenshot, i still have 2 remaining hrs in row 14 but will become1 hr only when i input 11:00pm in cell H2;
- however, should time start has yet to come, the committed hrs will reflect instead of the time difference; row 19 should remain 1 until 5am and will be 0 when we came at 6:00 am mark

78584

thanks in advance,

Rhon
 

Attachments

  • Overtime Filing.xlsx
    12.5 KB · Views: 3
Back
Top