Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
roxigirl85
 | Femeie
25 ani
Bucuresti
cauta Barbat
30 - 46 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
I haven't found a direct formula to do this - doesn't mean there isn't.
I want to convert HDD Power-on time which is in hours to years, months and days. Knowing that the average life span of a HDD is about 5 years, I want to know how much life is left in it.
Yes there are software that can do it automatically for HDD/SSD (CrystalDiskInfo).
But I wanna know.
Enough said, let's get to the point.
I have 25363 hours Power-on time is 2 years, 10 months and 21 days.
For that I had to combine 2 independent formulas I found (see sources).
My 25363 hours are stored in cell G10. Here's the formula:
=DATEDIF(0;CONVERT(G10;"hr";"day");"y")&" years " &DATEDIF(0;CONVERT(G10;"hr";"day");"ym")&" months "&DATEDIF(0;CONVERT(G10;"hr";"day");"md")&" days"
Normally CONVERT(G10;"hr";"day") is a cell containing days, but since I had hours I first had to convert them to days.
Sources:
hours to days: https://support.microsoft.com/en-us/off ... 12cd57334f
days to years + months + days: https://www.extendoffice.com/documents/ ... -date.html
Just days to years:
=DATEDIF(0;C1;"y")&" years " &DATEDIF(0;C1;"ym")&" months "&DATEDIF(0;C1;"md")&" days"
_______________________________________
|
|
| |
|
