TAGALOG EXCEL TUTORIAL: How to Make Automated Daily Time Record (DTR) Using Excel? (W/ COMPUTATION)

[@mariojrlagumbay6168]

thank you sir sa tips dati di ko lang pinapasin mga ganito peru pag subject to promotion ka laking tulong nitong blog mo.

[@rjdexceltutorial4986]

You can also use this one =text(c2-b2, "H")

[@sherwinashleycalma9314]

salamat kuys!!

[@kayceekosca673]

galing mo. maliwanag kong napakinggan 😇 salamat ng marami..

[@mommyvisvlog]

Thanks for this sample how to make DTR. Thank you sir i learned a lot😊

[@ThedzAlarte]

Welcome po. Happy to help. 🥰

[@donnamhayvillanueva6419]

Hello thankyou po .. sobrang laking tulong hehehe . Ang linaw po ng pag kaka explained

[@ThedzAlarte]

Welcome po. 🥰

[@donnamhayvillanueva6419]

Hello po ulit .. ksi ginawa ko pala sya ngayon .. bakit po pag 10:00am - 12:00am po ang total hours po na nalabas ay -10 po? Bakit po hindi sya 14?

[@donnamhayvillanueva6419]

5hours per day po kasi ung O.T KO .. minsan 6hours . Paano po? Para d sya maging negative?

[@jaypeecarjoe8366]

Paano po gawing yung time format na instead of 6pm/ 06:00:00 PM gawing 18:00:00

[@jerryditalo7772]

pano po yong may night differential,restday work, special holiday work, regular holiday work?

[@asjforexgloballimited9588]

Idol panu po kung 3x Ka nag time in tsaka 3x din nag time out..halimbawa nag time in aq 7:35am tas nag time out nnman pag dating Ng 9:39am Kase umuwi aq tas nag time in nnman aq 12:23pm tas nag time out nnman 4:38pm Kasi may pinuntahan nnman aq tas nag time in nnman aq 7:43pm tas time out 10:38pm...panu po BA Yan idol..patulong po 😁 sumakit na ulo cu tulog payroll time.. thank you 😊

[@wiredmusictelevision2575]

Boss musta po? Patulong Sana ako regards to excel file format or file extension is not valid. Verify that you the file has not been corrupted and that the file extension matches the format of the file. Ya po ang lumalabas kapag imo open ko yung file. Many thanks po. God Bless.

[@ValerieVanAlano]

Bighelp gawa ka din po video ng leave monitoring

[@jandrictuiza4542]

Paano gumawa ng format ng dtr with overtime and night differintial sa isang column lng cya po?

[@jho-anavkv535yamugan4]

Sunod po sana Pang retail business hehe

[@rodezatv]

🙏🙏🙏🙏🙏🙏hello po..laking tulong po pero pwede po ba bang add nong overtime, together withs tutorial, please

[@NirvanaFlame025]

Hi sir pwde po ba kayo makapag tutorial ng ganitong tutorial din pero this time kasama ang mga deductions sa mga benefits like sss, philhealth..etc..?

[@joanmartinez6683]

up

[@emersonnato8170]

hi po paano po pag every week from morning shift to afternoon shift sa isang cutoff? paano po ang formula? salamat po

[@francesimogen1699]

Request po, Ung pang security DTR po. 148 guards po.

[@jexikabarquilla]

Sa gross pay sir bakit po pag clinick ko po ung F4 unghourly rate na 60 unglumalabas..

[@ryaabangon356]

hi paano po pag Kasama luncbreak at coffee break tapos yung late po automatic kung ilan ang lates

[@sophzxie8834]

Hourly rate is different from OT rate. Incorrect ang lalabas sa gross mo kasi nag base ka pa din sa HR kahit na nag OT kana ng 2 hours sa FEB.2 mo. Gross = Total HR + Total OT

[@yong-898]

Boss may video ka kung paano gawin ang Bank Balance with transaction? Thanks

[@sheridanjosephjugador]

Idol example Kong may overtime sa Excel saan elalagay?

[@rumelluar2369]

pano po yung exel attendance na automatic na yung total overtime kung meron po ..

[@jerocelbasca272]

done subscribe Thedz💜

[@antoninovillete8229]

Sir paanu po un merun night differencial thank u

[@hermiedeleon846]

What if weekly - 1 per lunch?

[@candelariaballesteros3677]

Panu po pag bukod Ang ot pay?

[@nicasanjose5473]

Hello po, paano po gumawa or ano po Ang formula para sa Morning (in and out) and Afternoon (in and out). Paano po sya macompute?

[@claudinesantolaja5802]

Hi sir panu po yong formula if 5 pm po in nya then out nya is 1am ng madaling araw? Thanks po

[@leandrocastidades9584]

sir ask ko png paano kapag mag dadagdag ka ng transportation allowance sa dtr

[@MedardoPacariem-el4ee]

Papano po yung night diff at OT na may night diff?

[@nanoeyes21]

meron ba computation na may night shift?

[@batang-gas2763]

Paano e separate ang day shift at night shift time at saka total hours ng day ang night time

[@haleytrevorrepato7542]

Paano po pag nag halfday

[@rumelluar2369]

pano po yung maraming staff ... ito kase for single staff lang ... please ..
Salamat po

[@maryannevalencia4636]

How to compute a biometric attendance, Yong simple lng sir

[@kimazor7698]

Hi po baka meron po kayong format sa night diff po hehe thanks a lot

[@michaelaperez0318]

HI SIR HOW Salamat po. how about the undertime po kaya?

[@johnrhey2303]

" #Value " Any formula?

[@soundsreelme8654]

Pano po pag madaling araw out

[@iancaesarcatayas6763]

wht if po In/out AM tas In/Out PM

[@catibogmeynard]

Sirnpd po ba malaman fb pages mo
Para mas madali kapag magpapaturo po ako

[@agap.meraki8837]

paano po naging automated yan?

[@jeromepadilla3477]

Paano makuha yung late?

[@allanexala2913]

Kulang po panu kung may ot

[@superinday3087]

need help po..yung sa formula po #VALUE! po yung lumalabas :(

[@fambamwithtresmariasph]

Oo nga Bakit ganun

[@JWDCHANNEL]

About sap aman po

[@iandavebaroro3521]

paano nman kapag late ung iccompute mo ?

[@oohshiela9491]

=total number of lates/60
ex.
=15/60 = 0.25 (late)
*To get the no. of work hours:
=8-0.25= 7.75 (total number of worked hours)

[@rosemarievalencia1152]

Gumawa Ako pero ang lumalabas ay #value!

[@marianhymiel2211]

Misleading ang subject ng excel mo. Ikaw pa rin naman nag input ng time in mo. Nasan dyan ang automated?

[@henryhighlights]

😬😬😬

[@jerocelbasca272]

done subscribe Thedz💜