With
A1: a number of weeks and partial weeks.....9.8
This regular formula returns that value formatted as you indicated:
In that example, the formula returns this text: 9 week(s) 5 day(s) 14 hour(s) 24 minute(s)![]()
B1: =INT(A1)&" week(s) "&TEXT(MOD(A1,1)*7,"d \d\a\y\(\s\) h \h\o\u\r\(\s\) m \m\i\n\u\t\e\(\s\)")
Is that something you can work with?
Bookmarks