Originally Posted by
concepcion.jensen
Hi Richard,
I wanted OT less than an hour not to be computed because in our policy, only OT that is 1hour above is valid for pay, I wanted the cell in OT that will only show OT (1 hour above) but if its less than 1 hour it will be not computed. Is this possible? and also i am encountering issue if the time in or time out goes after midnight (12:00 am).
also how about the scheduled in and out computation?
please refer to the attached file.
Did you use the formula I gave you in post #5 which does cater for times that straddle midnight.
i.e.
The IF element of the formula adjusts for midnight if necessary
Bookmarks