In Excel I have cells that contain durations, stored as date (integer part) plus time (fraction) as usual. Now I would like to format the values to see the number of elapsed days plus the remaining hours and minutes, e.g. **34 days and 13:37**.

I tried all [cell formats](https://docs.microsoft.com/office/troubleshoot/excel/format-cells-settings) I could think of. I *can* format as total number of hours and minutes elapsed (`[u]:mm`: 829:37) for instance:

```
FORMAT         34,56789      but:

[u]:mm         829:37        how many days is that?
d u:mm         3 13:37       incomplete for 32+
j-m-d u:mm     00-2-3 13:37  month is 1 too high :-(
[d] u:mm       #VALUE!       [d] not understood :-(
0 u:mm         #VALUE!       cannot combine number and date/time formats :-(
0,00           34,57         translate the decimals into hours by hand :-(
not possible?  34 13:37      this is what I would like!

```

Note that formats and results use Dutch regional settings here. US would use `y` instead of `j`, `h` instead of `u` and `.` instead of `,`.

So... I cannot format it like `34 13:37`?

Of course I could use a formula, but that would take an extra column in my case.