View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Calculate Accrued Time

What constitutes 2 weeks (14 days, 10 working days)? What happens if they
started 2 weeks and 3 days ago?

--

HTH

Bob

"Heather" wrote in message
...
Good morning! I have searched for this, and couldn't find anything that
satisfied what I'm looking for. I'm hoping to find some help with this. I
need a formula that will auto calculate time accrued (PTO) at a rate of
5.85
hours every 2 weeks. I know employee start dates, and have the current
balance of PTO, just need to be able to add to it w/ out having to go
through
our payroll system & manually update for each person. Thank you!
--
~*Heather*~