#05 Time Sheet in MS Excel | With Salary Slip | Employee Over Time | Employees Payroll | Part 1-02

preview_player
Показать описание
Time Sheet in MS Excel | With Salary Slip | Employee Over Time | Employees Payroll | Part 1
In this video tutorial you will be able learn how to make a time sheet, how to calculate daily and monthly worked hours and over time, how to use countif, if, iferror, text, eomonth and sumproduct functions, how to make employees payroll and much more.
Don't forget to subscribe our channel for more cool videos.

#timesheet
#overtime
#advanceexcel
Download the file here.
Рекомендации по теме
Комментарии
Автор

awesome tutorial. clapping for your work.
#saleemskills

SALEEMSKILLS
Автор

Work hours includes OT and lunch time. How to calaculate working hours without OT and Lunch time. Also how to calculate salary by working hours?

tradingviewstox
Автор

Agar time 23:00 rat ko suru hota hai aur subah 7:00 ko khatam hota hai to iska count kaise aayega

jtcretion
Автор

Please send the formula of total working hours and total
I can't understand ur language bcoz I am south Indian
Please guide me

BrindhaRamesh
Автор

Hello bro
I want to count (Sunday + holiday) in months
Please tell me.

ahsan
Автор

How to change the weekend from Sunday to Wednesday

pirate.
Автор

10:40 bhai pura sunday ko red kaise kiya. mai kar raha hu tho 1 sub column hi ho raha hai sunday collumn se. please help

ompatel
Автор

Sir Time sheet ke upper apni biometric punching kaise ayegi

chawlaconfectionery
Автор

Bhai aapne over time rate per day ka nikala he jab k over time rate per hour k hisaab se hota he. Kindly isko Sahi Karen aur mujhay correct formula bataega

SheikhPostings
Автор

if the staff is working form 0900 to 0030 hrs the working hr is showing in negative bhai

beingananimals
Автор

and ap WhatsApp group banay jis ap esy sheet and format shear kr sakain please

miankashif
Автор

If there is break in and break out how to culcute

adnankhanluckyboy
Автор

Bro I want to count weekends (Saturday & Sunday(2Days) as weekend instead of just Sunday 1 off day.

muhammadjawad
Автор

Yeh formula to physicly is not doing work

rajkumarbhati
Автор

Hard to see clearly because the camera was not closed.

saudhs
Автор

Sir ag koi leave aa jati hai like 14 aug ya Eid ki tu phir us ko kesy manage karin gy

toqirtufail
Автор

kya aap mera question solve kar sakte ho ?

DVG
Автор

Sahi to hi magar video saf nahi dikh raha hai kripya sahi video dikhayee

dushyantkumar
Автор

Hi,
How to copy the value of B 1, E1, I1, M1 and so all in
A5, A6, A7, A8 and so all
Please help me. If any video in this regard please send the link.
Thanks

rathinmondal
Автор

Thanks bro ...your video is very useful may Allah bless you ...and have mercy on you where are you... I follow your channel can you give me the whatsapp number.

subairmachincheri