add a number every two weeks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a worksheet that calculates vacation time earned per pay
period. I need a formula to add 6 hours to a cell every two weeks. Can this
be done?
 
If you want the result in time format try....

=(INT((TODAY()-DATE(2006,11,15))/14)+1)*"06:00"

format as [h]:mm

this will show 06:00 on the date in the formula and increment by 6 hrs every
14 days

If you want to make it easier to maintain put the start date in a cell, e.g.
A2 and the number of hours (06:00) in another, e.g. B2 and use the formula

=(INT((TODAY()-A2)/14)+1)*B2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fx for vacation 2
Vacation Tracking formula 1
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
I need help to set up a spreadsheet 1
formula Help 2
advanced 'if' multiply 2
How to sum when the criteria and the range are in the same row? 2
How do I calculation vacation accrual? 1

Back
Top