Untitled.jpg
Hye Pal,
I'm looking any way to insert formula in column "Duration" in format as per instance above? Meaning that, if the duration is 1 month and above, the extra days is shown in days not in week. If the the duration is 1 week and above (not exceed than 1 month), the extra days is shown in days. Also, if the duration is 2 week for instance, it will only appear 2 weeks instead of "0 month 2 weeks 0 days". It is possible to be that way?? Any expertise out there?? Please help =)
Thanks in advance!
Bookmarks