add 25 hours every day since now

sjoerdieman

New Member
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.

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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!

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

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

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)

Replies
1
Views
288
Replies
0
Views
167
Replies
3
Views
144
Replies
12
Views
614
Replies
3
Views
376

1,203,171
Messages
6,053,874
Members
444,692
Latest member
Queendom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back