Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
L.J.
 
Posts: n/a
Default sum month, help

Thanks you for pointing out the resouces.
However I still have a difficult to calculate the time interval.
This is what I have do
column A column B
column C

1
Date in
Date out
interval

2
Jul-03 (mmm,yy)
Aug-04
=datedif(B2,A2,"m")

3
Jan-04
Sep-04




The result is "#NUM!", how should I format cell C2?
Is there any step I went wrong?

Your help would be much appreciated.

LJ

"JE McGimpsey" wrote in message
...
Alternatively, if you want the "time spent" in other units, check out
the DATEDIF function:

http://cpearson.com/excel/datedif.htm


In article ,
"JulieD" wrote:

assume
Date in is cell B2
Date out is cell C2
formula for D2
=C2-B2
format as number to get the number of days that the tenant stayed.


"LJ" wrote in message
...
I am working in the building and have to calculate the time span each
tenant
stayed . I have "date in" and "date out" and "time spent" columuns.
Does
anyone can give the formula for "time spent" column?



  #2   Report Post  
L.J.
 
Posts: n/a
Default

Sorry, I have to send it again, because it does not appear what I posted
originally.

1. In cell B2, I entered Jul-03 (cell is formatted mmm,yy) as Date In
2. In cell C2, I entered Jun-04 (cell is formatted mmm,yy) as Date Out
3. D2 is for "interval time" : I used formula -- datedif (C2,B2,"m")
And the result I got is "#NUM!".

How should I format Cell D2? Which step I went wrong?
Any help would be much appreciated.

LJ



  #3   Report Post  
JulieD
 
Posts: n/a
Default

Hi

the formula you use should be
=datedif(b2,c2,"m")

the syntax is
=datedif(startdate, enddate,timeunit)

Cheers
JulieD

"L.J." wrote in message
...
Sorry, I have to send it again, because it does not appear what I posted
originally.

1. In cell B2, I entered Jul-03 (cell is formatted mmm,yy) as Date In
2. In cell C2, I entered Jun-04 (cell is formatted mmm,yy) as Date Out
3. D2 is for "interval time" : I used formula -- datedif (C2,B2,"m")
And the result I got is "#NUM!".

How should I format Cell D2? Which step I went wrong?
Any help would be much appreciated.

LJ





  #4   Report Post  
L.J.
 
Posts: n/a
Default

Thanks Julie. One more question year, if the period of spent time is 13
months, is there any syntax can show 1 year 1 month?

Regards,
LJ


  #5   Report Post  
JulieD
 
Posts: n/a
Default

Hi LJ

yes you can - Chip Pearson has a good example of how to do this, (using an
Age calculation but it should give you an idea) on his web page about using
datedif at

http://www.cpearson.com/excel/datedif.htm#Age

it's using the concatenation operant of & e.g.
if A1 was John and B1 was Smith
=A1 & " " & B1
would return
John Smith

Regards
Julie Dall

"L.J." wrote in message
...
Thanks Julie. One more question year, if the period of spent time is 13
months, is there any syntax can show 1 year 1 month?

Regards,
LJ




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm to select current month or earlier Steve Excel Discussion (Misc queries) 2 January 21st 05 10:41 PM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 04:07 PM
Is it possible to grab just the Mondays-Thursdays of every month? Arlen Excel Discussion (Misc queries) 5 January 4th 05 09:29 PM
How can I format a cell so date field only displays the Month? tk_2u Excel Discussion (Misc queries) 3 December 4th 04 01:54 AM
Pivot Table - Group by Month - Show Items with no data Dan Reynolds Excel Discussion (Misc queries) 0 November 28th 04 02:01 AM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"