Notifications
Clear all
Topic starter
Hello,
I would like to change decimal time (positive or negative) into days and hours and minutes.
Ex : 53.5 would be 2 days 5 hours 30 minutes
Ex : -0.25 would be -15 minutes
Thanks!
Posted : 21/04/2021 11:27 am
Use this formula
=IF(D8>24,ROUND(D8/24,0)&" Days "&ROUNDDOWN(D8-(ROUND(D8/24,0)*24),0)&" Hours "&ROUND((D8-((ROUND(D8/24,0)*24)+ROUNDDOWN(D8-(ROUND(D8/24,0)*24),0)))*60,0)&" Minutes",ROUND(D8,0)&" Hours "&IFERROR(RIGHT(D8,LEN(D8)-FIND(".",D8)+1)*60,0)&" Minutes")
Posted : 22/04/2021 5:28 am
Topic starter
Thank you Vasim. Unfortunately the formula only gives me the days and not the days, hours and minutes.
How could I add those?
Thanks!
Posted : 22/04/2021 7:07 am
Works perfectly for me - did you look at the attached file?
Posted : 22/04/2021 4:22 pm
