Excel! help me !?

Question

Ok, I need to make a work schedule i want to be able t put in the shifts and it add it for me at the end can i do this .. also can i make it subtract the break too! Help someone!

Answer 1

Column A: name of employee
Highlight columns B through D, click on format, click on cells, click on number, and make sure the decimal places says 2.
Column B: start time (use military time for hours and minutes should be in decimal; percent of hour. This is easiest if rounded to nearest quarter hour. I.e, 8:15 would be 8.25, and 8:30 would be 8.50, and 8:45 would be 8.75).
Column C: end time (see above)
Column D: start time of break
Column E: end time of break
Column F: click on F1, click on the AutoSum button (it looks like a funky backwards 3), You'll see in a rectangle above the spreadsheet, fx=SUM(B1:E1). Click in that rectangle, and change it to say =SUM(C1-B1)-(E1-D1). Your F column should now have the actual hours worked calculated for you.
Now, you don't need to do this for every row. Have your cursor in F1, click on edit, click on copy, highlight down the F column as far as you need to go, click on edit, click on paste. Now, it will do the math for each of your employees.

Answer 2

This is my sweetheart of software...... I love Excel.
too detailed to explain here, but if send me an e-mail, I'll send you an excel file set up.

Answer 3

try the template supplied by Microsoft