| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add a number every two weeks
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
add a number every two weeks
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 "Big Rob" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detecting Cancel in an InputBox Method | Excel Discussion (Misc queries) | |||
| Non updatable Unique Random Number | Excel Worksheet Functions | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
| Need number of months or weeks passed from formula | Excel Worksheet Functions | |||
Linear Mode
