networkdays

  • Thread starter Thread starter babs
  • Start date Start date
B

babs

=TEXT(REPLACE(E3,LEN(E3)-1,0," ") - REPLACE(B3,LEN(B3)-1,0," "),"d:h:mm:ss")
Is calc for 1st value shown since comes in as text with no space between
min.&am or pm



=NETWORKDAYS(J9,H9)
5:1:02:00 09/09/2009 10:49 AM 09/04/2009 09:47 AM 4
4:10:22:00 09/08/2009 08:16 PM 09/04/2009 09:54 AM 3

feel like the number of working days should be 3 and 2 days if skipping the
weekend Sept 8 is a Fri. and Sept. 4 is a Tues.

not clear on why showing up as 3 working days???? anyway I can just add
formula to the 5:1:02:00- to calc. working days???

thanks,
barb
 
=TEXT(REPLACE(E3,LEN(E3)-1,0," ") - REPLACE(B3,LEN(B3)-1,0," "),"d:h:mm:ss")
Is calc for 1st value shown since comes in as text with no space between
min.&am or pm



=NETWORKDAYS(J9,H9)
5:1:02:00 09/09/2009 10:49 AM 09/04/2009 09:47 AM 4
4:10:22:00 09/08/2009 08:16 PM 09/04/2009 09:54 AM 3

feel like the number of working days should be 3 and 2 days if skipping the
weekend Sept 8 is a Fri. and Sept. 4 is a Tues.

not clear on why showing up as 3 working days????
Click to expand...

Read HELP for NETWORKDAYS so you can understand how it works
anyway I can just add
formula to the 5:1:02:00- to calc. working days???

thanks,
barb
Click to expand...

networkdays("9/4/09","9/9/09")

Friday, September 04, 2009 --> Working Day
Saturday, September 05, 2009
Sunday, September 06, 2009
Monday, September 07, 2009 --> Working Day
Tuesday, September 08, 2009 --> Working Day
Wednesday, September 09, 2009 --> Working Day

I count four (4) working days.

--ron
 
I guess i really want # of days worked - 4th -7th =1day
7-8 =2 day
8-9=3 day - do I just subtract1 from the answer - How does it handle my # of
hours in a day???

YOU KNOW alot about dates and time!! thanks for still helping,
Barb
 
1:6:11:00
this is 1 day 6 hours etc.

How can I calculate total HOurs in above time - sb 30 plus hours

thanks again,barb
 
I guess i really want # of days worked - 4th -7th =1day
7-8 =2 day
8-9=3 day - do I just subtract1 from the answer - How does it handle my # of
hours in a day???

YOU KNOW alot about dates and time!! thanks for still helping,
Barb
Click to expand...

Well, NETWORKDAYS gives the number of days worked.

If you came in to work on Sep 4, and worked every workday through Sep 9, you'd
want to be paid for 4 days, not 3. That's how the NETWORKDAYS function works.
But if you are looking for simple subtraction, then yes, subtracting 1 from the
answer will give you that result consistently.
--ron
 
1:6:11:00
this is 1 day 6 hours etc.

How can I calculate total HOurs in above time - sb 30 plus hours

thanks again,barb
Click to expand...

Use the data/text to columns wizard to split the entries into 4 cells (use a
":" as the delimiter). Then use a formula like: =A1*24+B1+C1/24+D1/1440
--ron
 
Hello - sorry had to work on something else
the 1st column is acutally a result of a calc. - so i had to copy and paste
special-values - would prefer to Not have to to the copy paste- anything I
can add to formula?? also see other issue below

0:13:18:00 0:00:00 13 18 0
0:13:09:00 0:00:00 13 9 0
0:12:11:00 0:00:00 12 11 0
1:6:11:00 0:00:00 6 11 0
1:3:19:00 0:00:00 3 19 0
1:2:53:00 0:00:00 2 53 0
See above - for some strange reason when I went to split the columns the Day
column(one with all the 0's) does not show the right number of days
Not sure what I am doing wrong???

thanks barb
 
Hello - sorry had to work on something else
the 1st column is acutally a result of a calc. - so i had to copy and paste
special-values - would prefer to Not have to to the copy paste- anything I
can add to formula?? also see other issue below

0:13:18:00 0:00:00 13 18 0
0:13:09:00 0:00:00 13 9 0
0:12:11:00 0:00:00 12 11 0
1:6:11:00 0:00:00 6 11 0
1:3:19:00 0:00:00 3 19 0
1:2:53:00 0:00:00 2 53 0
See above - for some strange reason when I went to split the columns the Day
column(one with all the 0's) does not show the right number of days
Not sure what I am doing wrong???

thanks barb
Click to expand...

What is the "calc"?
What is the cell format?
--ron
 
Back
Top