calculate age

[CrashMatRob]

I know you can calculate your age in days by
date born A1= 30/09/1978
and B1= today()
= A1-B1

but can I calculate days and time born - today's date and time?
date born A1= 30/09/1972 16:20
and B1= now()

To find the result number of days and hours

Thanks
Rob
www.CrashMatRob.com

 

[Pete_UK]

Yes, of course you can - just apply a custom format to the cell to
display days and time. Note, though, that NOW() changes more often
than TODAY() - everytime you recalculate the sheet the value will be
updated. You will also have to subtract the birthdate and time away
from NOW, i.e. =B1-A1.

Hope this helps.

Pete

 

[Bob Phillips]

=FLOOR(B1-A1,1)&" days, "&TEXT(MOD(B1-A1,1),"hh:mm:ss")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[CrashMatRob]

Thanks for the help,

I found Mr. Bob Phillips formula did what I was looking for.

Thanks again
Rob
www.CrashMatRob.com

(e-mail address removed)