Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I make an Employment Schedule that Tabulates hours worked.
I am trying to develop an excel spreadsheet that will show the scheduled
hours worked as well as allow me to tabulate the total number of hours for each worker as well as total hours per day. I attempted to use ="7 AM" - "5 PM" function, but it was unable to handle the data in that order. I would prefer to be able to post the schedule so others can see it as well as have it auto tabulate the hours. Thank you for your help. Alicia |
#2
|
|||
|
|||
Hi Alicia,
See John Walkenbach's Employee Time Sheet workbook which is freely downloadable at: http://www.j-walk.com/ss/excel/files/timesht.htm --- Regards, Norman "Alicia" wrote in message ... I am trying to develop an excel spreadsheet that will show the scheduled hours worked as well as allow me to tabulate the total number of hours for each worker as well as total hours per day. I attempted to use ="7 AM" - "5 PM" function, but it was unable to handle the data in that order. I would prefer to be able to post the schedule so others can see it as well as have it auto tabulate the hours. Thank you for your help. Alicia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
I would like to make a schedule for my dept. Who works what days . | Charts and Charting in Excel | |||
I would like to make a schedule for my dept. Who works what days . | Charts and Charting in Excel | |||
Hours worked | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |