email?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can i email someone a small section of my spread sheet
that im having trouble getting to compute correctly. i
don't think i could do a good enough job explaining my
problem with out you seeing what i have done.
 
Hi
you should first try to explain it in plain text. If this will not help
someone will surely offer you to email the file to him. But first try
at least :-)
 
for some reason im getting what seems to be a ghost .40 in
colums that have no hours worked towards the end of the
week if i change some of the numbers in rows 5,6 it will
appear in J9, or J11 or I11.


monday is column C
sunday is column J

Row 8 is total of daily hours worked in straight time
C8=IF(C5+C6+C7>=40.01,C6+C7+C5-C10,C5+C6+C7)
D8=IF(D5+D6+C5+C6+D7>=40.01,D6+D7+D5-D10,D5+D6+D7)
E8=IF(E5+E6+E7+D5+D6+C5+C6>=40.01,E7+E6+E5-E10,E5+E6+E7)
And formula continues to J8

Row 9 is same as above but converted into minutes to role
the value to the next whole number at .6
C9=INT(C8)+HOUR(MOD(C8,1)/14.4)+(MINUTE(MOD
(C8,1)/14.4)/100)
D9=INT(D8)+HOUR(MOD(D8,1)/14.4)+(MINUTE(MOD
(D8,1)/14.4)/100)
Formula continues to J9

Row 10 is total of overtime if any
C10=IF(C5+C6>40,C6+C5-40,0)
D10=IF(D5+C5>40.01,D5+C5-40-C10,0)
formula cont. to j10

Row 11 is same as above but converted into minutes to role
the value to the next whole number at .6
same formula as Row 9



row 5 usually will have a values of .15 on days that are
worked and work at least 4-7 days

Row 6 will have values ranging from 6 to 14 and could also
have decimals up to .59 4-7 days out of the week

Row 7 is the same as 6 but thats benifit time and get
subtracted from row 10.
 
Hi
sounds like a rounding issue. Though I wonder why you don't use a time
format but a decimal entry. If you like email me your file (and
highlight in the file there the error is)
email: frank[dot]kabel[at]freenet[dot]de
 
Back
Top