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 con...
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