Equation to add X hours every Fortnight

**Trace86** · 09-28-2011, 02:42 AM

Hi all,

I was just wondering if anyone could help me with coming up with a formula in which I can acheive the following:

=(number of hours - x)+ (start date, every fortnight add xhours (eg. 1.4))

In words, how do I work out an equation where I have a start date so on every fortnight from this date I can add X?

Is excel able to do that?

Thanks for your help

**daddylonglegs** · 09-28-2011, 03:57 AM

If you have start date in A2 and hoursto add in B2 then try this formula in C2

=INT(MAX((TODAY()-A2)/14,0))*B2

assumes that the hours are added first 14 days after A2 date then every subsequent 14 days basehd on today's date

**Trace86** · 09-28-2011, 08:19 PM

Thank you

it works perfectly

Equation to add X hours every Fortnight

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Equation to add X hours every Fortnight

Re: Equation to add X hours every Fortnight

Re: Equation to add X hours every Fortnight

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions