Hi Every one,
I need help to create a Employee weekly Time sheet as per below details.
| NAME | TIME IN | TIME OUT | LUNCH | TOTAL HRS |
| - 1/2 HR (TO BE DEDUCTED) |
I know it looks simple for an expert, I am doing this manually, would like to keep a record.
I tried on format custom timings its not giving me the proper answer.
Please help.
Hi Peter,
Basic time sheet is easy to do, if you just know how. If you not already have taken one already, I can suggest that you will learn lots by taking any of the courses here. The Excel course is a good starting point. https://www.myonlinetraininghub.com/microsoft-office-online-training-courses
Apart from the courses you can learn a lot by looking into templates. A good source is https://templates.office.com.
To help you out, please upload a sample file with data, that will give us a better understanding of what you are doing and where you get stuck. Otherwise we will try to help based on assumptions.
Br,
Anders
Thanks for quick response Andre, I will explain what I have and what I need.
What I have:
NAMES Monday Tuesday Wednesday Thursday Friday Saturday Sunday Total
| 1 | 8.00 | 8.50 | 8.00 | 8.00 | 7.50 | 40.00 |
What I need is:
| NAME | MONDAY | TTUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | DAILY TOTAL | ||||||||||||||||||||||||||||
| TIME IN |
|
TIME OUT | TOTAL |
|
LUNCH | TIME OUT | TOTAL | TIME IN |
|
TIME OUT | TOTAL |
|
LUNCH | TIME OUT | TOTAL |
|
LUNCH | TIME OUT | TOTAL |
|
LUNCH | TIME OUT | TOTAL | TIME IN |
|
TIME OUT | TOTAL | |||||||||
| NAME | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | 7.30 | 0.30 | 16.00 | |||||||||||||||
| the lunch .30 should be deducted from daily total | or 3.5 hours should be deducted from daily total |
|
||||||||||||||||||||||||||||||||||
Hello Peter,
Some more references to start with, check these sites for more information about calculating dates and times.
https://www.myonlinetraininghub.com/excel-date-and-time
So, now to your issue. It can be differencies due to localization, but can you use a dot (.) as a divider between hours and minutes? Normally the divider is a colon (:). Do try writing the time as 7:30 and 0:30 and 16:00, I do believe that it will solve your issue, just an assumption.
The formula you should have is =TIME OUT - (TIME IN + LUNCH).
Without a sample file I have based upon assumptions, I hope I have understood your issue correct.
Br,
Anders
First to correct written the time 07:30, 00:30 like this, And use this formula
=(Out time - In time+(Out time < In time))-Lunch Time
Hi,
There are other considerations to take into count when creating a time sheet, for example night and shift work. More about time calculation in this blog post. https://www.myonlinetraininghub.com/excel-time-calculation-tricks
Br,
Anders
