networkdays

[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

 

[Ron Rosenfeld]

=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????

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

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

 

[babs]

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

 

[babs]

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

 

[Ron Rosenfeld]

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

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

 

[Ron Rosenfeld]

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

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

 

[babs]

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

 

[Ron Rosenfeld]

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

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