Hello all,
Not sure how to explain this, I have a formula for day, hours and minutes in cell, =INT(S15-L15)& " Days " &HOUR(S15-L15) & " Hrs " &MINUTE(S15-L15)& " Mins ", but if the formula cannot calculate from the select cells (S15-L15), I would like it calculate the days, hours and minutes from different cells, (T15-E15).
Any help would be muchly appreciated.
Not sure how to explain this, I have a formula for day, hours and minutes in cell, =INT(S15-L15)& " Days " &HOUR(S15-L15) & " Hrs " &MINUTE(S15-L15)& " Mins ", but if the formula cannot calculate from the select cells (S15-L15), I would like it calculate the days, hours and minutes from different cells, (T15-E15).
Any help would be muchly appreciated.
Status | Received | Time between received and started | Started | Time taken to be completed or handed back if not completed | Completed | Handed Back if not completed | ||||||||||
Completed | 2/04/2023 20:42 | 0 Days 1 Hrs 3 Mins | 2/04/2023 21:45 | 1 Days 18 Hrs 14 Mins | 4/04/2023 15:59 | N/A | ||||||||||
Completed | 20/04/2023 11:05 | 0 Days 0 Hrs 0 Mins | 20/04/2023 11:05 | 0 Days 6 Hrs 43 Mins | 20/04/2023 17:48 | N/A | ||||||||||
Not Completed | 23/04/2023 23:37 | #VALUE! | N/A | #VALUE! | N/A | 28/04/2023 15:15 |