Forum Discussion
Format for time remaining when number of days exceeds 31
OS: Windows 10 Version 22H2 (OS Build 19045.2965)
Excel: Microsoft® Excel® 2021 MSO (Version 2305 Build 16.0.16501.20074) 64-bit
I have a column (column A) of expiry dates. The next column contains a formula showing the time remaining:
| 2023-08-16 | =A1-NOW() |
Rarely — but often enough — the number of days to expiry exceeds 31, but now the formula shows an incorrect value — for example:
How can I get the cell to show the correct number of days?
I tried using the format string "[dd] HH:mm" however that doesn't appear to be supported.
Also, please provide a link to a complete list of all supported excel formats.
1 Reply
That's if show as text
=INT( A4-NOW() ) & "d " & TEXT( MOD(A4-NOW(), 1 ), "hh:mm" )link, first in google, Excel custom number formats | Exceljet
