Tracking employee schedules with Excel?
February 1, 2005 9:11 PM Subscribe
Excel formula question. Using Excel as an employee scheduler and need to help trying to create a formula for tracking.
posted by cyniczny to computers & internet (3 answers total)
The schedule has the person's name, the time they begin work, and the time they end work. (Generally written as "John Doe 8:00 - 4:30"). I need to find a way to track how many hours the person works each day, minus their lunch time. I'm not very advanced with Excel, and the help is rather confusing, since I also need to convert to military time and account for days with no lunches and days off.
I have searched via Google for samples of similar spreadsheets to try and adapt a formula, but nothing appears to match my needs. The concept seems utterly simple, so I'm astonished that I haven't been able to solve this myself and am hoping someone could let me know a formula to use, or point me in the right direction. Thanks!