Thanks, everyone, for trying to help. I am not familiar enough with Excel for
any of this to make any sense to me -- I'm a beginner and have not worked
with Excel formulas AT ALL. So... I'm overwhelmed here. I wasn't expecting it
to be so complicated. I don't think I'm conveying myself correctly, either,
which may be part of the problem (for example -- the breaks have to be shown
as taken -- 10 minutes each in the morning and afternoon, but are NOT
subtracted from pay; they are PAID breaks...). The website I was directed to
displays a time sheet that looks nothing like mine, nor is it set up like
mine at all. So... I'm giong to have to try and find someone who can show me
in person what I need to do. Thanks anyway... If anyone wants to take a look
at the actual time sheet for me I could send it as an attachment. Then if the
first couple of lines could be formulated for me, I could copy the rest.
Otherwise, I'm at a loss.

"SteveW" wrote:

?? interesting use of SUM.. when + will do
together with 0.333whatever why not use (8/24)
which both explains what you are doing (selfdocumentation) and is accurate

On Tue, 22 Aug 2006 02:53:11 +0100, mudraker
wrote:


This formula add a1 and b1. if sum value greater than 8 hours it shows
8 hours. other wise it shows total value of added cell.

0.3333334 is the numeric value for 08:00

=IF(SUM(A1:B1)0.3333334,0.3333334,SUM(A1:B1))

This formula displays value greater than 8:00 munus 8:00

=IF(SUM(A1:B1)<0.3333334,"",SUM(A1:B1)-0.3333334)





--
Steve (3)