Hi,
I am new here but was wondering if anyone had a sheet that can calculate accrued vacation based on salary per pay?
Thanks
Janice
Hi,
I am new here but was wondering if anyone had a sheet that can calculate accrued vacation based on salary per pay?
Thanks
Janice
.
Does this final answer look correct to you ?
A B C D E F 1In Out Total Salary Earned Earned Leave 2 8:00 16:00 8 $10.00 $80.00 4.80 3 4C2 Formula : =(B2-A2)*24 5E2 Formula : =C2*D2 6F2 Formula : =E2*0.06
Yes this looks Perfect. Thank you so much. Just one question - what column / row would I put the formulas. I am just starting with excel. Any input would be greatly appreciated.
Last edited by jkronen; 10-04-2017 at 04:21 AM.
.
8:00 is 8 am ... 16:00 is 4 pm ... military time. Habit of mine to use 24 hour clock instead of 12 hour.
If the final answer is correct (4.80 hrs leave time) the formula is actually F2 Formula : =E2*6% (not 0.06) .... format F2 as NUMBER with 2 decimal places
Last edited by Logit; 10-05-2017 at 10:12 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks