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