software

I am trying to use Excel to make a simple time tracker. This is the
basic set up of my page:

Cells A4-R4 contain # of hours worked per day, say 5:30 (Time) in each
cell.

Cell A2 is a running total of A4-R4. This formula I have already done.

=SUM(A4:R4)

Cell A3 is the % of a total # of hours available that A2 is. For
example; A2 is 40 and the total available # of hours is 100 (which is
A1) then A3 would be 40%.

What would be the formula used to show the percentage of A1 that A2 is
if A1 is a number such as 100 and A2 is in time format? When I format
A2 to time my % gets screwed up each time I try it. Any ideas? A1 is
not in time format but is a General number format.

I also have A5, which is a running total of A1 (100) - A2. This also
does not work when I have A2 in time format. It gives me a number which
is close to the correct answer but just a little off.

Any help I coul get would be appreciated!

Thanks,
Terry--
Mustangman
------------------------------------------------------------------------
Mustangman's Profile: www.excelforum.com/member.php...oamp;userid=29903
View this thread: www.excelforum.com/showthread...hreadid=496096Try

=(SUM(A4:R4)*24)/A1

format as percentage

since one excel hour is 1/24 then you need to multiply with 24 to get
decimal format

--
Regards,

Peo Sjoblom

(No private emails please)quot;Mustangmanquot; gt; wrote
in message ...
gt;
gt; I am trying to use Excel to make a simple time tracker. This is the
gt; basic set up of my page:
gt;
gt; Cells A4-R4 contain # of hours worked per day, say 5:30 (Time) in each
gt; cell.
gt;
gt; Cell A2 is a running total of A4-R4. This formula I have already done.
gt;
gt; =SUM(A4:R4)
gt;
gt; Cell A3 is the % of a total # of hours available that A2 is. For
gt; example; A2 is 40 and the total available # of hours is 100 (which is
gt; A1) then A3 would be 40%.
gt;
gt; What would be the formula used to show the percentage of A1 that A2 is
gt; if A1 is a number such as 100 and A2 is in time format? When I format
gt; A2 to time my % gets screwed up each time I try it. Any ideas? A1 is
gt; not in time format but is a General number format.
gt;
gt; I also have A5, which is a running total of A1 (100) - A2. This also
gt; does not work when I have A2 in time format. It gives me a number which
gt; is close to the correct answer but just a little off.
gt;
gt; Any help I coul get would be appreciated!
gt;
gt; Thanks,
gt; Terry
gt;
gt;
gt; --
gt; Mustangman
gt; ------------------------------------------------------------------------
gt; Mustangman's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29903
gt; View this thread: www.excelforum.com/showthread...hreadid=496096
gt;