add 25 hours every day since now

[sjoerdieman]

I've a lathe that we bought 2 years ago.

Machine hours per week = 5 * 5
Machine hours per year = 25 * 52
Machine hours last 2 years, 2600 hours.

I want to make a calculation for my inspection file.
The calculation:

Before today, the machine runned 2600 hours
After today, every day passes adds 25 hours to the 2600 hours.

Anyone? please help!

 

[Maagaard]

Hi,

If you in "A1" have the today's date, in "A2" write the formula =Today() you can caculate the accumulated hour with this formula =2600+((A2-A1)*25)

hope this helps!

 

[BrianMH]

I assume you mean 25 hours per week instead of per day.

=2600+(INT((TODAY()-DATEVALUE("16-Jan-14"))/7)*25)

 

[BrianMH]

To only add on workdays and to make it daily.

=2600+((NETWORKDAYS(DATEVALUE("16-Jan-2014"),TODAY())-1)*5)

With network days you can even give a holiday range to skip them in the count.

=2600+((NETWORKDAYS(DATEVALUE("16-Jan-2014"),TODAY(),holidayrange)-1)*5)