How to represent a number in Excel as "XX days left, YY hours, ZZ minutes"?

Question

excel

Cell Title: "Time Remaining"
Content: 27.32456 hours
How do I represent this as days (days), hours, and minutes?
I try the format "d:H:M" - so it displays garbage - 23:6:33

Answer 1

We need to divide by 24.
* Attention: the Text formula in Russian-language Excel is "TEXT"
* In Russian-language Excel, it may make sense to use "dd HH:mm" for the format, depending on regional settings; if the file will be used on machines with different settings, it makes sense to take this into account in the formula (detect the language, use the appropriate format string).
Operation example:
entry / exit
27.32456 / 01 03:19
24.00000 / 01 00:00
24.25000 / 01 00:15
49.50000 / 02 01:30

Answer 2

I have LibreOffice, so it also displays an incomprehensible result for such a formula:
Formula: =TEXT(B9/24;"dd HH:mm")
Upd: MS Excel displays: 01 03:19
tin...