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 differencesNext: Auto Populate & Name Recognition