View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nathanv3223[_3_] nathanv3223[_3_] is offline
external usenet poster
 
Posts: 1
Default Formula and worksheet will not working properly

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