LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pref
 
Posts: n/a
Default Creating an exact time display

Hello Somebody,,
I could use some help with this one. I'm trying to create a formula using
MS Excel
because several persons will be using this file, and they should have this
software
on their machines.

OK, let's say that I wanted to determine the exact age of an individual that
has died.
I want everything figured in,,, like leap years and such.

I would like to enter two dates; their birth date and their date of death.
and I would like a date that formats something like one of the following:

49 "Years" & 72 "Days"
or like this:
49 "Years", 3 "Months" & 17 "Days"


Would appreciate any help along this line if I can get someone that's up for
the
challenge.....

Thanks in advance for your help,

Jeffrey Thomas


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time display grahammal Excel Discussion (Misc queries) 1 May 15th 06 11:40 AM
Time Display Question Please Bob Newman Excel Discussion (Misc queries) 3 February 2nd 06 07:48 AM
Time Display ? Bob Newman Excel Worksheet Functions 3 February 2nd 06 03:20 AM
conditional formatting with time values Access Idiot Excel Discussion (Misc queries) 2 September 13th 05 03:29 PM
Dynamic Time Display Jamie Vail Excel Worksheet Functions 3 September 7th 05 11:08 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"