Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
vrhodes
 
Posts: n/a
Default how to set excel to track attendance and vacation hours available

I've created an attendance sheet and want to place the letter "a" on days
employees are absent...How do I get the sheet to count the number of "a's" in
a calander year? Also, Vacation time is accrued at a rate of 3.3 hrs per
month...is there a way I can have it automatically add in those hrs?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Leith Ross
 
Posts: n/a
Default how to set excel to track attendance and vacation hours available


Hello vrhodes,

It would help to know more about how you have the Worksheet laid out.
Like, which cells will have the "A" and which cell will have the hours.
Is there only one sheet for the entire year with all the employees
listed on it or are the employees on separate sheets?

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=514063

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel as Attendance Tracker Donna123 Excel Discussion (Misc queries) 8 December 26th 05 07:39 PM


All times are GMT +1. The time now is 11:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"