Forum Discussion
Solved
date range calculations
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 col...
The formula would have to return a text result:
=IF(AND(W11<>"",W11<>"OPEN"),INT(V11-B11)&":"&TEXT(V11-B11,"hh:mm:ss"),"")
Assuming that the duration will never be more than 31 days:
=IF(AND(W11<>"",W11<>"OPEN"),V11-B11,"")
Format as dd:hh:mm:ss
Thank you, What if the duration is longer than 31 days? is there a formula that will cover both scenarios?
The formula would have to return a text result:
=IF(AND(W11<>"",W11<>"OPEN"),INT(V11-B11)&":"&TEXT(V11-B11,"hh:mm:ss"),"")
- excellent, thank you 🙂