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.
|