Aug 09 2022 06:41 AM - edited Aug 10 2022 07:10 AM
SOLVED
G'day, all. I'm needing some help with calculating time between two date/time entries only if another cell in that row is filled, if not, leave blank. Date entry minus Date exit if RESULT column is filled, otherwise leave blank. Thank you
Aug 09 2022 07:07 AM
Assuming that the duration will never be more than 31 days:
=IF(AND(W11<>"",W11<>"OPEN"),V11-B11,"")
Format as dd:hh:mm:ss
Aug 09 2022 11:12 PM
Aug 10 2022 01:37 AM
SolutionThe formula would have to return a text result:
=IF(AND(W11<>"",W11<>"OPEN"),INT(V11-B11)&":"&TEXT(V11-B11,"hh:mm:ss"),"")
Aug 10 2022 01:37 AM
SolutionThe formula would have to return a text result:
=IF(AND(W11<>"",W11<>"OPEN"),INT(V11-B11)&":"&TEXT(V11-B11,"hh:mm:ss"),"")