Forum Discussion

harshjoshiD's avatar
harshjoshiD
Copper Contributor
Oct 02, 2022
Solved

Convert d.hh:mm Text to [h]:mm Duration

Hello,   I am a newbie to Excel and I have this sheet where the Duration has been listed in the format of d.hh:mm. I need it formatted into [h]:mm. E.g., '2.04:37' will become 52:37 (52 hour...