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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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,547
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,547
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,141,924
Messages
5,709,372
Members
421,633
Latest member
Ubergribbler

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