Hi!
Here's some ideas.
In your HOURS column,column G, I would suppress the
display of the of all the zeros. It will look better! You
can do it by either going to ToolsOptionsView and
uncheck Zero Values, or writing your formula in column G
to test for the Time Out cell being blank:
=IF(E1="","",E1-C1)
To get the total paid hours:
What is that "star" symbol?
=SUMIF(J5:J32,"<",G5:G32)
To get the unpaid hours:
=SUMIF(J5:J32,"="&"",G5:G32)
Total unpaid hours:
=G33-G35
Biff
-----Original Message-----
Hi,
I made a simple timesheet that keeps track of my hours
and is set up to go
past the 24 hr mark. What I want to do is subtract my
paid hours from my
unpaid hours. So if I have 25:15:00 total hours minus
10:00:00 paid hours it
should come out to 15:15:00 unpaid hours. Total hours is
cell G33 with the
formula =SUM(G5:G32), total paid hours is cell G35 with
the format of
9/12/2004 10:00:00 AM, and total unpaid hours is cell
G37 with the formula
of =G33 - TIME(10,0,0).
What I want is a formula so that all I have to do is
change the "Paid hours"
(G35), number and the "Unpaid hours" (G37), will change
automatically. See
my timesheet at
http://www.misscarlasbbq.com/timesheet.htm Any help would
be
greatly appreciated.
Thanks in advance,
Jerry
.