![]() Therefore 1 hour would be deducted off the Saturday total hours, 30 minutes would be deducted from the Sunday total hours and nothing taken off the Tuesday. in the example above Person A would be entitled to a 1 hour unpaid lunch on Saturday, a half hour unpaid tea on Sunday and no unpaid break on Tuesday. However what I would also like Excel to do is deduct the unpaid breaks which the person is entitled to, however this depends on the times that they work, i.e. ![]() (Note, we multiply by 24 to convert the decimal values into hours). ![]() Knowing this, you can simply subtract the start time (Clock In) from the end time (Clock Out) to find the time worked. I found out that I can do this using a formula to work out hours and minutes between two times. Calculate Hours with a Simple Formula In Excel, times are stored as decimal values. This is simple enough to create but I also need Excel to calculate how many hours each person is working in a week and the total number of hours used per day and per week. I am currently trying to create a rota / rosta for work which will show people what hours they are required to work, in a format similar to below:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |