Thread: date formats
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt
 
Posts: n/a
Default date formats

I have a cell that works out how many days someone has worked in my company
for. However, I'm trying to change the format of that cell so rather than it
saying, for example 743 as days, I want it to show as years, months, days i.e
2:01:15

Any ideas?