Forum Discussion
harshjoshiD
Oct 02, 2022Copper Contributor
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...
- Oct 03, 2022
harshjoshiD Please see the attached file, containing one way to solve this.
Riny_van_Eekelen
Oct 03, 2022Platinum Contributor
harshjoshiD Please see the attached file, containing one way to solve this.
harshjoshiD
Oct 03, 2022Copper Contributor
Thank you very much 🙂