![]() |
#6
|
|||
|
|||
![]()
Glad to help.
Actually I set a range to the active document, then looked for something that looks like the start of a date, then moved the end of the found range to the end of its paragraph (not including the mark), then verified it was a date. As for the function. I didn't do all of that on a lark today. I've tinkered with code to return a calculated age based on a birthday but never took it past years, months and days. Today I groomed that code to drill down to seconds. It may appear classy but I sit in a pile of scalp and bloody hair. I am not the whiz kid with dates and math functions. Not quite 30 but almost 20. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate time over two dates | Diver | Excel | 3 | 07-22-2017 11:31 PM |
![]() |
aymanharake | Excel | 6 | 02-17-2017 04:22 PM |
Calculate Time in Hours and Percent | pabyford | Excel | 6 | 12-13-2016 12:29 PM |
![]() |
Catherine | Project | 1 | 02-19-2014 11:15 AM |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |