Rhon Alvarez
Member
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
thanks in advance,
Rhon
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
thanks in advance,
Rhon