Forum Discussion
Number format problem for large amounts of tim
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of mi...
While Excel supports custom number formats for duration in seconds, minutes or hours, it does not support custom number formats in days or months. Using days and/or months in a number format always works as calendar days and months. The lowest calendar month is 1, not 0, so you never get 0 months.
You can replace a formula such as =SUM(B2:B5) with
=LET(s, SUM(B2:B5), INT(s)&" d "&TEXT(s, "hh ""h"" mm ""mn"""))
=LET(s; SOMME(B2:B5); ENT(s)&" j "&TEXTE(s; "hh ""h"" mm ""mn"""))