formula to add sickness/annual leave in sheet

hey guys im looking for a formula that will count the amount of hours each staff member worked in the month- i can get this part but i want it to record sickness days and Annual leave days

V = 7.5 Hrs
S = 7.5 hours

please see my attachment

thanks

Thank you can i ask if its can i add another column (no of days worked)where it will add the the amount of days worked(not the hours) so if it says for example 5 on the 1st and 7.5 on the 2nd it will return total of 2

thanks again much appreciated

As a human resources professional, you are required to juggle a variety of tasks. Your responsibilities could include everything from acquiring the best talent to motivating employees to managing training programs.

With so many different duties, it is important to have a system in place to stay organized and ensure that no detail is left undone. One way to keep track of all the details is by using an Excel template. But how do you find the best Excel templates to fit your needs? We’ve researched the top Excel templates for human resources and have included them here for you to download, along with a description of when to use each.
Candidate Tracker

where can i find them ?

here is a good absence tracker

http://www.healthyworkinglives.com/d...icationID=5559

Originally Posted by Toonies

here is a good absence tracker

http://www.healthyworkinglives.com/d...icationID=5559

Thanks this is very helpful

Hi Iv,e revised your Employee Tracker

Originally Posted by Toonies

Double post, taking ages to finish submitting reply

Toonies this is excellent, i was originally going to use this on a set of 10 staff who are all on the same hours, but now i see this want to use as onestop shop for all 30 staff. the only issues i can see will be the Vacation and sickness calculation as we have staff on different hours such as
11.75hrs
7.15hrs
6hrs
5hrs
10hrs
6.25hrs

can you maybe add some sort of table so that if a add v1 it adds 5hrs to total and so on for the other hours- if this is a lot of work then i understand if you cant add it. what you have giving me already is brilliant.thank you

cheers - was thinking if its possible for sickness for 1,2,3,4 hours ect and same with Vacation---- sometime staff get away early a couple hours rather that a full shift -

Originally Posted by Toonies

hi here is a revised version

It meets your requirements to input Hours, "S", "V" and have variable contracted hours assigned by individual employee by day

I have protected all sheets, to keep integrity of workbook.

there is no password set so if you need to unprotect it is easy to do

Thank again - really appreciated

thanks again

I will look at your latest request for variable Sickness and Vacation Hours

Originally Posted by Toonies

I will look at your latest request for variable Sickness and Vacation Hours

Brilliant - this is going to help me so much

here is the revised Employee Tracker, it caters for fixed contracted hours and variable Sick and Vacation hours

Brilliant - works a treat

glad I could help. Remember to mark your Thread Solved