If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
email?
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. |
#2
|
|||
|
|||
email?
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 :-) -- Regards Frank Kabel Frankfurt, Germany wrote: 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. |
#3
|
|||
|
|||
email?
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+C640,C6+C5-40,0) D10=IF(D5+C540.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. -----Original Message----- 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 :-) -- Regards Frank Kabel Frankfurt, Germany wrote: 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. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
can't open email | Jeff Philips | Outlook Express | 13 | June 27th, 2004 07:35 PM |
Bulk Email with different data to each recipient | Ava Healy | General Discussion | 1 | June 8th, 2004 08:08 AM |
Bulk Email with different data to each recipient | Ava Healy | General Discussion | 1 | June 7th, 2004 09:22 PM |
INBOX Emails Deleted/Disappear | 10,000 Emails Disappear/Deleted | Outlook Express | 4 | June 4th, 2004 05:35 PM |