perhaps
=TEXT(A2/(24*60*60),"dd \d\a\y\s h \h\o\u\r\s m \m\i\n\u\t\e\s")
reduce to days and as above
perhaps
=TEXT(A2/(24*60*60),"dd \d\a\y\s h \h\o\u\r\s m \m\i\n\u\t\e\s")
reduce to days and as above
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks