California - Bay Area S2000 Owners California Bay Area S2000 Owners Group

excel help!

Thread Tools
 
Old 08-09-2008, 09:29 AM
  #1  
Registered User
Thread Starter
 
disxpnoi's Avatar
 
Join Date: Feb 2007
Posts: 302
Likes: 0
Received 0 Likes on 0 Posts
Default excel help!

So I am working on our turn around time and I need to know the formula to get it.

example : column A is (day started) 6/25/2008 and column b is (day finished) 6/28/2008.

Does anybody know the formula for this? I was thinking =(B-A) but date is different from values.

help! thanks!

Francis

**I googled this but no simple answers..
Old 08-09-2008, 09:33 AM
  #2  

 
Voodoo_S2K's Avatar
 
Join Date: Aug 2001
Location: Bay Area, California
Posts: 17,792
Likes: 0
Received 3 Likes on 3 Posts
Default

How about this?

http://articles.techrepublic.com.com/5100-...11-1040561.html
Old 08-09-2008, 09:36 AM
  #3  
Registered User
Thread Starter
 
disxpnoi's Avatar
 
Join Date: Feb 2007
Posts: 302
Likes: 0
Received 0 Likes on 0 Posts
Default

thanks vu! found it!!
Old 08-09-2008, 10:06 AM
  #4  
Registered User

 
Cyberous's Avatar
 
Join Date: Apr 2005
Location: Hollister, CA
Posts: 1,511
Likes: 0
Received 0 Likes on 0 Posts
Default

Originally Posted by disxpnoi,Aug 9 2008, 09:29 AM
So I am working on our turn around time and I need to know the formula to get it.

example : column A is (day started) 6/25/2008 and column b is (day finished) 6/28/2008.

Does anybody know the formula for this? I was thinking =(B-A) but date is different from values.

help! thanks!

Francis

**I googled this but no simple answers..
Your formula is correct, In your formula cell change the format to number.

What else do you have,.. Excel is my life
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Tachus
S2000 Vintage Owners
14
01-09-2017 04:17 PM
timdonna1
S2000 Vintage Owners
0
10-27-2008 04:03 AM
Legal Bill
S2000 Vintage Owners
26
09-26-2008 06:35 PM
AATees
Texas - North Texas S2000 Owners
12
06-07-2008 08:25 AM
pkboi323
California - Bay Area S2000 Owners
17
05-03-2007 01:47 AM



Quick Reply: excel help!



All times are GMT -8. The time now is 02:36 PM.