Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel as Attendance Tracker
Merry Christmas Everyone!! I've posted this on another board - got lots of views but no responses so I'm hoping Santa will be good to me and someone reading this thread will have an answer. We have 100+ employees. We need to track PTO, Vacation in hours and then also log other instances of time away from work (f= fmla, t=travel, c=comp time, h=work at home). However these "other instances" do not need to be tracked in terms of hours used. The only suggestion that came on the other board was to have 3 rows per employee - not a good solution. My solution so far has been to have 3 columns for each day but this is causing me to run out of columns before I get to April. I thought I could use SUMIF but apparently I'm wrong. Why can't I put something like "8v" (indicating 8 hours of vacation used) and then have my totals column look at the range and sum if it says 8v, the column next to this would sum if it said 8p. Any help would be appreciated. -- Donna123 ------------------------------------------------------------------------ Donna123's Profile: http://www.excelforum.com/member.php...o&userid=26962 View this thread: http://www.excelforum.com/showthread...hreadid=495940 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
document tracker using Excel not Access | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |