Prev: compare two columns and pull out differences
Next: Auto Populate & Name Recognition
From: igorin on 11 Feb 2010 11:01
Hello,

How can I format the number 8.3568 into:

8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds?

Thank you!
From: Luke M on 11 Feb 2010 11:08
It would help if we knew what your logic was. Why does 8.3568 equal that
specific time frame?

Normally, that time frame, which could be written as:
4/8/1908 10:45:07 AM

Would have a numerical value in XL of 3021.447998
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"igorin" wrote:

> Hello,
>
> How can I format the number 8.3568 into:
>
> 8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds?
>
> Thank you!
From: Daryl S on 11 Feb 2010 11:39
Igorin -

If you use a 360-day year, then the decimal year is converted as follows:

Here are the assumptions:
Months in a Year 12
Days in a year 360
Hours in a day 24
Minutes in an hour 60
Seconds in a Minute 60

Decimal Years 8.3568
Years 8.00 (integer portion of line above)
Remaining Years 0.3568 (difference of two lines above)
Months 4.00 (integer portion of line above divided by 12)
Remaining Years 0.0234667 (difference between .3568 and 4/12)
Days 8.00 (integer portion of line above * 360)
Remaining Years 0.001244 (difference between .0234667 and 8/360)
Remaining Minutes 645.120000 (line above * 360*24*60)
Hours 10.00 (integer portion of line above / 60)
Remaining Minutes 45.1200 (difference of two lines above)
Minutes 45.00 (integer portion of line above)
Remaining Minutes 0.12 (difference of two lines above)
Seconds 7.00 (integer portion of line above * 60)
--
Daryl S


"igorin" wrote:

> Hello,
>
> How can I format the number 8.3568 into:
>
> 8 years, 4 months, 8 days, 10 hours, 45 minutes and 7 seconds?
>
> Thank you!
 | 
Pages: 1
Prev: compare two columns and pull out differences
Next: Auto Populate & Name Recognition