date formats

M

Matt

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?
 
D

David Biddulph

Matt said:
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
Click to expand...

=DATEDIF(A1,A2,"y")&":"&DATEDIF(A1,A2,"ym")&":"&DATEDIF(A1,A2,"md")

.... (but for inputs of 0 and 743 it gives 2:0:12, not your 2:01:15).
 
N

Niek Otten

See

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

--
Kind regards,

Niek Otten

|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?
 
Top