hat
Kòm yon anplwaye konpayi, nou bezwen ponpe nan ak kout pyen soti chak jou travay, konte total la travay tan ak mwens lè a manje midi nan yon jounen ka ede yo kalkile salè dapre tan an. Pou egzanp, mwen gen dosye sa a chak jou prezans ki gen ladan boutèy demi lit, louvri sesyon ak kòmanse manje midi, fwa fen semèn manje midi nan yon Fèy travay, kounye a, mwen vle kalkile èdtan total yo te travay, men mwens lè manje midi chak jou. Pou fini travay sa a, mwen ka prezante kèk fòmil pou ou.
eng
As a company employee, we need punch in and punch out every work day, counting the total worked time and minus the lunch time of a day can help to calculate salary according to the time. For example, I have the following daily attendance record which contains log in, log out and lunch start, lunch end times in a worksheet, now, I want to calculate the total hours worked but minus lunch time each day. To finish this job, I can introduce some formulas for you.