Hey all,
This will probably seem a simple and easy problem for many of you, but im not very experienced with excel (hence why I'm here )
I'm trying to create a roster/timesheet excel doc for my own record keeping regarding what hours im rostered on and work, the pay im entitled to etc. (I've been having a problem lately with my employer not paying me the correct rates (they vary depending on the day) or the correct amount for the hours ive worked.)
I work a rotating roster including night shift. What I would like to be able to do is write down that on friday i am rostered on at say 21:00 and finish the next day at 08:00 (Saturday is charged at a higher rate than friday, so the 8 hours worked on sat would have to be calculated seperately than friday.) I may also start another shift on saturday night and go on until sunday morning.
the way my company sets out their payslips is quite stupid imo, but its easier to understand it if i could format my own records in this way.
what i am having trouble with is figuring out a way to do this so i dont have make a set of cells for each hour (broken in to two, in case i start/finish at half past) without putting a 1 in each second cell that im rostered on and then using the sum formula to calculate the amount of 1's that i've put down -_-
Is there a way of making it so i can just write 21:00 - 08:00 and it fills it in (perhaps with a colour rather than a character) and then calculates the amount of coloured cells (divided in half)?
Here's a link to the rough sheet that i've put together so far so as to perhaps help you understand what i mean.
http://www.savefile.com/files/2162356
thanks,
joel
p.s. far out i wish i had found this site and forum sooner. ive had so many excel questions in the past and just tossed the project aside when i couldn't figure out what to do next.
This will probably seem a simple and easy problem for many of you, but im not very experienced with excel (hence why I'm here )
I'm trying to create a roster/timesheet excel doc for my own record keeping regarding what hours im rostered on and work, the pay im entitled to etc. (I've been having a problem lately with my employer not paying me the correct rates (they vary depending on the day) or the correct amount for the hours ive worked.)
I work a rotating roster including night shift. What I would like to be able to do is write down that on friday i am rostered on at say 21:00 and finish the next day at 08:00 (Saturday is charged at a higher rate than friday, so the 8 hours worked on sat would have to be calculated seperately than friday.) I may also start another shift on saturday night and go on until sunday morning.
the way my company sets out their payslips is quite stupid imo, but its easier to understand it if i could format my own records in this way.
what i am having trouble with is figuring out a way to do this so i dont have make a set of cells for each hour (broken in to two, in case i start/finish at half past) without putting a 1 in each second cell that im rostered on and then using the sum formula to calculate the amount of 1's that i've put down -_-
Is there a way of making it so i can just write 21:00 - 08:00 and it fills it in (perhaps with a colour rather than a character) and then calculates the amount of coloured cells (divided in half)?
Here's a link to the rough sheet that i've put together so far so as to perhaps help you understand what i mean.
http://www.savefile.com/files/2162356
thanks,
joel
p.s. far out i wish i had found this site and forum sooner. ive had so many excel questions in the past and just tossed the project aside when i couldn't figure out what to do next.
Last edited: