Hourly Timesheet Excel: Hours Sheet
Solved
Choupi33
-
Line -
Line -
Hello,
So, today I would like to create an Excel sheet where I can log my working hours. Currently, I'm doing it by hand, but with Excel, there would be very little chance of making a mistake.
I've already seen some topics on this, but the coded language is illiterate to me, I don’t understand anything :(
Could any of you either redirect me to a GOOD topic or simply help me with my Excel spreadsheet, please?
I would like to input the arrival time (e.g., 8:30), the break time (similarly, 12:30), the end of the break, and the departure time from work.
Additionally, I would like a calculation to keep track of the hours worked in a day, in a week, in a month, and in a year, and to insert a formula that takes into account days off, sick days, and RTT.
Is my request feasible?
Thank you in advance for your replies! :)
Have a good day! :)
So, today I would like to create an Excel sheet where I can log my working hours. Currently, I'm doing it by hand, but with Excel, there would be very little chance of making a mistake.
I've already seen some topics on this, but the coded language is illiterate to me, I don’t understand anything :(
Could any of you either redirect me to a GOOD topic or simply help me with my Excel spreadsheet, please?
I would like to input the arrival time (e.g., 8:30), the break time (similarly, 12:30), the end of the break, and the departure time from work.
Additionally, I would like a calculation to keep track of the hours worked in a day, in a week, in a month, and in a year, and to insert a formula that takes into account days off, sick days, and RTT.
Is my request feasible?
Thank you in advance for your replies! :)
Have a good day! :)
1 réponse
Hello Choupi33.
I propose this: https://www.commentcamarche.net/telecharger/bureautique/9697-fiche-de-pointage-excel/
To be improved as needed.
(:-)>--<
"Repel evil with good; and behold, he with whom you had animosity will become like a warm friend" (Quran)
"He who does not know how to share is deprived of his emotions." (Marc Levy)
I propose this: https://www.commentcamarche.net/telecharger/bureautique/9697-fiche-de-pointage-excel/
To be improved as needed.
(:-)>--<
"Repel evil with good; and behold, he with whom you had animosity will become like a warm friend" (Quran)
"He who does not know how to share is deprived of his emotions." (Marc Levy)
I will be leaving from your great base! Thanks again!!!
Happy holidays! :)
Assuming that the entry time is in D2 and the exit time is in E2, the number of hours worked can be calculated as follows:
The formula checks if the person left on the same day, in which case it applies the calculation , otherwise (if they left the next day) it applies the calculation .
Did this solution address your concern?
I hope so :)