Formula and worksheet will not working properly

  • Thread starter Thread starter nathanv3223
  • Start date Start date
N

nathanv3223

can someone help me with a formula it is not giving me the right times. The
formula is supposed to figured the time between dates. It is not giving me
the right times. sometimes its high and sometimes its lower than what it
should be. I hope someone can help me i need this for keeping track of my
employees and questions please contact me.

The formula is
=IF(G2="","",(((NETWORKDAYS(F2,G2,$W$2:$W$22)-1)/3+MOD(G2,1)-MOD(F2,1)+((MOD(G2,1)<0.5)-(MOD(F2,1)<0.5))/48)/E2))

I can email you the sheet I am talking about it you would like. I can't
attach my sheet
 
You can mail the file to me with a few correct values as well which you
expect to get from the formula...
Also pl. explain what you are trying to find using the formula so that it is
easier to understand..

You can also upload the file at a site like wikisend.com and paste the link
here... do prepare and post a sample file without confidential data.
 
Back
Top