Making a schedule using excel. HELP
Posted by Eddie S. on July 30, 2001 9:09 AM
Recently I was asked by my boss to see if I could make a work schedule showing the employees time (10-5, 1-9:30, etc) their total hours and the payroll dollars used. I have done the total hours and payroll dollars ok, but I am having troubles getting Excel to convert the time slots into hours. Example: I want Excel to convert 10-5 into 6.5 hours. I know I will probably have to make the calculations on another page, but is this fomula possible? Basically I need a lot of help here. Thank you in advance!