ClarusDignus

Convert days in decimal to years, months, days, hours, minut

Oct 20th, 2017
396
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. =INT(C8/365)&" Years, "&INT(MOD(C8,365)/30)&" Months, "&ROUND(MOD((MOD(C8,365)),30),0)&" Days "&INT((C9-INT(C9))*24)& " Hours "&INT((((C9-INT(C9))*24)-INT((C9-INT(C9))*24))*60)&" Minutes "&ROUND((((((C9-INT(C9))*24)-INT((C9-INT(C9))*24))*60)-INT(((((C9-INT(C9))*24)-INT((C9-INT(C9))*24))*60)))*60,0)&" Seconds"
Advertisement
Add Comment
Please, Sign In to add comment