software

I am trying to keep track of the hours and minutes a machine has operated.
This can get up to 20,000 hours. How do I add daily operating hours to the
begining total?

A|re you storing the values of time and finding it can only go as far as 24?
If so, format the cell as [h]:mm

--

HTH

RP

quot;BPHMAquot; gt; wrote in message
news
gt; I am trying to keep track of the hours and minutes a machine has operated.
gt; This can get up to 20,000 hours. How do I add daily operating hours to
the
gt; begining total?
I think it would be better keeping these as numeric, rather than in
Excel time format. You might have a cumulative total in column B, with
the daily total hours in A. In B2 this simple formula will give you
what you want:

=A2 B1

and this can be copied down as necessary. If A is derived from start
and end times somewhere else and these are stored in Excel date format,
you can convert to hours by multiplying by 24.

Hope this helps.

PeteBob,
I am using [hh]:mm. This works fine until I get to 10,000 hours, then
when I try to Sum cell a1 and a2 it doesn't work.

quot;Bob Phillipsquot; wrote:

gt; A|re you storing the values of time and finding it can only go as far as 24?
gt; If so, format the cell as [h]:mm
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt;
gt; quot;BPHMAquot; gt; wrote in message
gt; news
gt; gt; I am trying to keep track of the hours and minutes a machine has operated.
gt; gt; This can get up to 20,000 hours. How do I add daily operating hours to
gt; the
gt; gt; begining total?
gt;
gt;
gt;

Ah, yes. I remember this problem.

I found earlier that this was a problem, that it was an Excel oddity. I
found that as long as you keep below 10000
for the base number, you can continue adding it without problem.

This may not be ideal, but if you use something like a running total, it
should work. The trick is never to try adding a cell that is greater than
10000. As long as they arev all below, it adds and shows okay.--

HTH

RP

quot;BPHMAquot; gt; wrote in message
...
gt; Bob,
gt; I am using [hh]:mm. This works fine until I get to 10,000 hours, then
gt; when I try to Sum cell a1 and a2 it doesn't work.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; A|re you storing the values of time and finding it can only go as far as
24?
gt; gt; If so, format the cell as [h]:mm
gt; gt;
gt; gt; --
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; RP
gt; gt;
gt; gt; quot;BPHMAquot; gt; wrote in message
gt; gt; news
gt; gt; gt; I am trying to keep track of the hours and minutes a machine has
operated.
gt; gt; gt; This can get up to 20,000 hours. How do I add daily operating hours
to
gt; gt; the
gt; gt; gt; begining total?
gt; gt;
gt; gt;
gt; gt;
Thanks for the information. I need to keep track of hours of operation and a
lot of the machines have over 10,000 hours. I guess the best way to do that
would be to keep number in numeric format and write a formula so that 60
minutes will equal one.

quot;Bob Phillipsquot; wrote:

gt; Ah, yes. I remember this problem.
gt;
gt; I found earlier that this was a problem, that it was an Excel oddity. I
gt; found that as long as you keep below 10000
gt; for the base number, you can continue adding it without problem.
gt;
gt; This may not be ideal, but if you use something like a running total, it
gt; should work. The trick is never to try adding a cell that is greater than
gt; 10000. As long as they arev all below, it adds and shows okay.
gt;
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt;
gt; quot;BPHMAquot; gt; wrote in message
gt; ...
gt; gt; Bob,
gt; gt; I am using [hh]:mm. This works fine until I get to 10,000 hours, then
gt; gt; when I try to Sum cell a1 and a2 it doesn't work.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; A|re you storing the values of time and finding it can only go as far as
gt; 24?
gt; gt; gt; If so, format the cell as [h]:mm
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; RP
gt; gt; gt;
gt; gt; gt; quot;BPHMAquot; gt; wrote in message
gt; gt; gt; news
gt; gt; gt; gt; I am trying to keep track of the hours and minutes a machine has
gt; operated.
gt; gt; gt; gt; This can get up to 20,000 hours. How do I add daily operating hours
gt; to
gt; gt; gt; the
gt; gt; gt; gt; begining total?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

I think something else would be need in the formula. Since 60 minutes equals
1 and it is different when adding decimal numbers.

quot;Petequot; wrote:

gt; I think it would be better keeping these as numeric, rather than in
gt; Excel time format. You might have a cumulative total in column B, with
gt; the daily total hours in A. In B2 this simple formula will give you
gt; what you want:
gt;
gt; =A2 B1
gt;
gt; and this can be copied down as necessary. If A is derived from start
gt; and end times somewhere else and these are stored in Excel date format,
gt; you can convert to hours by multiplying by 24.
gt;
gt; Hope this helps.
gt;
gt; Pete
gt;
gt;


You can modify Pete's approach.

With your machine total so far in decimal hours in B1 and times to be
added (in time format) in A2 down use

=B1 A2*24 formatted as general or number

copy down column--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=501979I can't seem to make this work. I have a machine with 12,300 hours and 23
minutes. I want to add daily operating time to this total. For example 3
hours 21 minutes. How do I do this in excel?

quot;daddylonglegsquot; wrote:

gt;
gt; You can modify Pete's approach.
gt;
gt; With your machine total so far in decimal hours in B1 and times to be
gt; added (in time format) in A2 down use
gt;
gt; =B1 A2*24 formatted as general or number
gt;
gt; copy down column
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=501979
gt;
gt;

You have to realise that if you store the hours as numeric, then 100.5
and 200.25 represent 100 hours 30 mins and 200 hours 15 mins
respectively. However, if you really want to show this as hours and
minutes, the following formula in C2 will do this:

=TEXT(INT(B2),quot;0quot;)amp;quot; hrs quot;amp;TEXT((B2-INT(B2))*60,quot;0quot;)amp;quot; minsquot;

Copy this down column C for as many values as you have in A and B. You
can then hide column B if this causes confusion.

Hope this helps.

Pete