View Single Post
  #2   Report Post  
Fred Smith
 
Posts: n/a
Default

Use the Date function.

=date(26,48,278)

will convert to the proper date (which, by the way, is 30 years, 9 months, 4
days)

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Tanya" wrote in message
...
What formula would I use to convert the following information into service
time? For example: 26 yrs 48 mos. 278 dys needs to be converted to 30
yrs
7mos 8 dys.