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

Formula and worksheet will not working properly
 

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

Attatchments.

To upload a workbook, click reply then add your few words, scroll down
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 trouble
please use this link or the one at the bottom of the
any page.

nathanv3223;257498 Wrote:
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

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886

Formula and worksheet will not working properly
 

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" wrote:

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

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.

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


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

--
nathanv3223
------------------------------------------------------------------------
nathanv3223's Profile: http://www.thecodecage.com/forumz/member.php?userid=159
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886

Formula and worksheet will not working properly
 

Post moved to correct forum!

nathanv3223;258577 Wrote:
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.

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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886

Formula and worksheet will not working properly
 

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
------------------------------------------------------------------------
nathanv3223's Profile: http://www.thecodecage.com/forumz/member.php?userid=159
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886

Formula and worksheet will not working properly
 

this promblem is fixed


--
nathanv3223
------------------------------------------------------------------------
nathanv3223's Profile: http://www.thecodecage.com/forumz/member.php?userid=159
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886

Formula and worksheet will not working properly
 

nathanv3223;376355 Wrote:
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)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71886