Hi all!
Here I have a formula:
=IF(AND(E4<>"",X25<>"",Q25<>"",S25<>""),INT(E4+X25-Q25-S25)&" Days "&TEXT(E4+X25-Q25-S25,"h:mm"),"")
But I need to combine it with MOD function. How?
Thanks!
Hi all!
Here I have a formula:
=IF(AND(E4<>"",X25<>"",Q25<>"",S25<>""),INT(E4+X25-Q25-S25)&" Days "&TEXT(E4+X25-Q25-S25,"h:mm"),"")
But I need to combine it with MOD function. How?
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks