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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
LaraTaner pe Simpatie
 | Femeie
19 ani
Prahova
cauta Barbat
24 - 52 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2237
|
|
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:
days to years + months + days:
Just days to years:
=DATEDIF(0;C1;"y")&" years " &DATEDIF(0;C1;"ym")&" months "&DATEDIF(0;C1;"md")&" days"
_______________________________________
|
|
| pus acum 4 ani |
|