Hello,
I am looking to create an Excel spreadsheet to track employees VAC, Sick And Admin Leave, while calculating usage. I also need the sheet to show dates time was used and to increase at anniversary dates? Is this possible?
Hello,
I am looking to create an Excel spreadsheet to track employees VAC, Sick And Admin Leave, while calculating usage. I also need the sheet to show dates time was used and to increase at anniversary dates? Is this possible?
There are dozens, maybe even hundreds of examples on this board, (time sheet questions might be the number 1 question on the boards) each one different because the user has different needs. Do some searches and come up with one that fits you best. Then try to modify it if you need to.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Attendance History 2015 A.xlsm
I need help getting the spreadsheet to calculate sick time? Help Please
Which formula are you looking for?
In W4, it would be
=IF(P3="","",REPT("|",(AJ38/(U8+U9))*100)&" "&ROUNDDOWN((AJ38/(U8+U9))*100,1)&" %")
You might want to put an IFERROR around that should U8+U9 = 0
error.png
I tried that a hundred time already! see attached image to see wat it yells at me. Sorry if I am being a pest
Sorry, I can't see attached images. I am guessing you are getting
#DIV/0 ?
That is because there is nothing in U8
Can you help me to figure out why the sick time isn'tchanging according to the start date on the setup page.
Staff Time Accrual Workbook.xlsm
In U8 of Demby sheet, try
=VLOOKUP(DATEDIF(P3,TODAY(), "Y"), 'Set Up'!$H$7:$K$11,2)
I'm not sure what you are doing with this in U10
=IF('Set Up'!O7-O9>0,IF(P3="","",(U8-AJ38)+U9),"")
I'm thinking you want 'Set Up'!O7-'Set Up'!O9>0 but wouldn't that always be false?
Hi
I am a complete idiot when using excel. I have read excel for dummies approx 10 times. I am looking to have the sick, vacation and al time accrual update automatically according to anniversary dates. it seems to be working for all fields except SICK DAYS (U8).
Okay, use the formula I gave above in U8. Currently there is no formula in there so will be empty.
You can add it to all employee sheets at the same time by "Grouping the sheets"
Hold the CNTRL Key down while clicking on each Employee sheet. Then type in the formula, then right click on a sheet tab and choose "Ungroup"
It worked beautifully thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks