LinkBack URL
About LinkBacks
With
A1: 68.6
Maybe this:For that example, the formula returns: 2 month(s) 8 day(s) 14 hour(s) 24 minute(s)
=INT(A1/30)&" month(s) "&TEXT(MOD(A1,30),"d \d\a\y\(\s\) h \h\o\u\r\(\s\) m \m\i\n\u\t\e\(\s\)")
Does that help?
With
A1: 68.6
Maybe this:For that example, the formula returns: 2 month(s) 8 day(s) 14 hour(s) 24 minute(s)=INT(A1/30)&" month(s) "&TEXT(MOD(A1,30),"d \d\a\y\(\s\) h \h\o\u\r\(\s\) m \m\i\n\u\t\e\(\s\)")
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks