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 |
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 |
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com