apologize for steppin over other question and still need help with dates formulae!
Posted by Francisco J. Estaba S. on August 21, 2000 5:41 PM
Hi, as i stated before, i´m a Judge in Venezuela who is confronting problems creating a Worksheet to calculate times of conviction.
Celia has helped Before, but as i was creating the Worksheet i discovered that then i had to introduce the time of the imprinsonment (?) as follows:
Years Months Days Hours Minutes
1 5 22 2 30
Then i have to add that much time to a "given" date as 22/8/00
Also, i have to take 2/3, 1/3, 1/2, 1/4 to the initial amount of years, months days, hours and minutes and add it too to the second date, that is the day the convict initiates his conviction.
Problems is that this is not all. I also have to calculate the amount of time elapsed since the initial detention of the convict to the day of today, and that date becomes the "given" date i mentioned before...