I inhertited a sheet that numbers are entered like 31.00.
The formatting applied would convert this to 31 days/ 0 hours/0 minutes
I have discovered that if a number over 31.00 is applied, a month value triggers and the calculation starts over with day 1.
So 36.00 would be 5 days.
This is what I inherited.
[<1]"00 days" hh "Hours" mm "Minutes" ;[>=1]dd "Days" hh "Hours" mm "Minutes";
Is there a way to make it keep calculating days after 31? So that 36.00 would show as 36 days and 00 hours?
Bookmarks