Formula and worksheet will not working properly

[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

 

[Simon Lloyd]

Nathan, you joined our forum, you can add an attachment there, if yo
find this thread and post in it the people who have been helping o
following can still do so :

Attatchments.

To upload a workbook, click reply then add your few words, scroll dow
past the submit button and you will see the Manage Attatchments button
this is where you get to add files for upload, if you have any troubl
please use this link or the one at the bottom of th
any page.

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

The formula i
=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'
attach my shee

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Sheeloo]

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.

 

[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 no
giving me
the right times. sometimes its high and sometimes its lower than wha
it
should be. I hope someone can help me i need this for keeping track o
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.

What i am trying to specificly do is get the time spent on one projec
in each row. So amount of time start time - end tim

+-------------------------------------------------------------------
|Filename: FORMULA.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=95
+-------------------------------------------------------------------

 

[Simon Lloyd]

Post moved to correct forum

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 givin
me
the right times. sometimes its high and sometimes its lower than wha
it
should be. I hope someone can help me i need this for keeping track o
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

What i am trying to specificly do is get the time spent on one projec
in each row. So amount of time start time - end tim

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[nathanv3223]

Please discard the last attachment i forgot to delete some stuff. Which
would make it real confusing. I have attached the new sheet again
please discard the other on only use the on attached to this reply.
Plus i would also like to add this explanation hopefully it will better
describe.
OK this is the sheet I would like you to look at. The formula has been
split into two but it works better than originally. Here is the formula
as a whole
=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)).

Now on this sheet it is split in two. First part is in column L and
the second is in M. It is supposed to give me the exact time spent on
this certain panel. feel free to mess around with it as much as you
would like.

The sheet using formula will give the time of how long it took (time is
not right/exact). It also gives the time variance. Then it subtracts
from all the boxes below all the columns. If you scroll down you will
see boxes in accordance with the columns above. It subtracts the
assembly time from those boxes if and when they have started and stopped
in the middle of the job. Again I have made it so when you enter the
info it is automatically transferred to the specific box and then
subtracted from the specific spot for that job for example.

Column a19 copies to a163 that is the jobs specific box they stop and
start every time they stop in the middle of building that job. The time
adds together in column d172

The column d172 is subtracted from m19 which is = up in o19 then
transfers to h19 if there is none in d172 then it transfers m19 but the
time in m isn’t right that’s the main problem the formula isn’t working.


Hopefully you can help. Please help


+-------------------------------------------------------------------+
|Filename: FORMULA.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=96|
+-------------------------------------------------------------------+

 

[nathanv3223]

this promblem is fixed

 

[Simon Lloyd]

this promblem is fixedNathan, thanks for letting us know...it's been a while, if you didn't

get the answer you needed you could have bumped your post back to the
forefront by simply replying ***bump***.

Anyway glad you're sorted!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)