iluvtolaff said:
I formatted it exactly the same as the other 2 'total' columns!!
That's the problem. Once you get beyond a certain number of hours the standard HH:MM format starts over again. Check your options for time format (In OpenOffice Calc it is referred to as
876613:37:46.
Right click on your totals cell and select "Format Cells"--- if you select time, you will be given many options. If you are using OpenOffice (v. 2.0.2) that will be one of them.
Here is an abbreviated time card:
I like blank spaces (& someone on this forum showed me how to do them). They keep my eyes from going buggy.
The appropriate formulas are:
D2:___ =IF(C2<>"";SUM(C2-B2);"")
G2:___ =IF(F3<>"";SUM(F3-E3);"")
H2:___ =IF((D2="")AND(G2="");"";D2+G2)
good luck,
letchworth