payroll

Hi all, I need to convert a time into a decimal, but also add a specific rounding function. For example, A1 shows the hours and minutes worked in the form of 8:39 (meaning 8 hours, 39 minutes). I want to convert this to a decimal in B1 and also round to the nearest quarter hour. Where...

Hello, Just wondering if anyone has a good, ready-built template for modeling direct payroll, or salary planning for a department. Ideally, something that allows for salary increase on a given date, as well as adjustments for vacancy (due to a position being temporarily open/vacant). At my old...

I've never really used anything except basic calculations in excel, so it's likely that this is a relatively simple maneuver, but I've been unable to figure it out on my own. Hoping you guys can help. This is for a scoring system in regards to a certification and raise promotion system at my...

OK... I've been staring at this for a few weeks now and I just cant figure it out. I work for a very complex company that change rules, schedules, pay etc. all the time. Because they do this, they have a horrible reputation for not getting our paychecks correct. So I wanted to create a...

Hi I am new to this forum and new to excel. I just started up my own buisness and have 8 employees. One of my freinds gave me a excel weekly time sheet. I copy the time card onto 1 single sheet and enter data every day many times for each worker. I have been using this for almost 1 year. My...

I cant for the life of my figure out why my formula won't recognize my 40:00 hours. I am trying to have it add up my timecard and put the regular hours in one cell and the overtime hours in another cell. I almost have it except for in the normal hour cell it wont recognize the 40:00 hours and it...

I am trying to multiply a normal number (1,2,3 etc...) by 20 minutes and have it display in in hours or minutes, whatever it may be. Example: If you do not take a break at my work, you get paid an extra 20 minutes. So I want to be abel to Have a place on the timecard that goes something like...

I am wondering if there is any other way to somehow link two functions together, to add hours in a timecard. I would like to be able to use decimals, but not have it convert into fractions. Example: I want to be able to go: Time in - 8.00 time out - 1.00 time in - 1.30 time out - 5.00. I want...