Hours, Running total

bobbych783

New Member
Joined
Oct 10, 2006
Messages
4
Hello

Im needing to do the following

keep a running totla of hours that a piece of industrial equipment has run.
E.g.

hours:mins run today 2:40

total Hours:mins run 11263:30 <<<<<(the current total is in excess of 11000 hours)

I need to input daily hours so it updates totals hours then delete daily hours but leave total hours rerady for next day. hope that makes sense

Cheers :biggrin:
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

bobbych783

New Member
Joined
Oct 10, 2006
Messages
4
Ok tried that, works fine with normal hours ie 02:30 + 04:20 but when try 02:30 + 12435:20 it dont like it??
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,723
Any entry over 9999:59 is taken to be text instead of time, when done as a cell entry. Sums of time can go way higher than that.

So ( if I'm right ), do a cell entry of =500+"453:20" and you'll be able to add to it. ( 500 = 500 days = 500 * 24 hours = 12000 hours )
 

bobbych783

New Member
Joined
Oct 10, 2006
Messages
4
Ok seems to work.

Next Q lol.

After input I want to delete the daily hours but leave the total hours uddated ready for the next daily input?
Cheers
Craig
 

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,723
Not knowing your layout I am only guessing here ... copy the summed result, and paste over the running total cell using Paste Special / Values, and then delete the daily hours.

I wouldn't be happy about such an arrangement in my workbooks ... I would want checking to make sure all entries were being processed, and that no entries were being processed more than once.
 

Forum statistics

Threads
1,176,427
Messages
5,903,063
Members
435,005
Latest member
AXILLIAN

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top