Hello Andrew,

Thanks for your reply! I tried out this formula as well however it does not work correctly for the second scenario as it gives me output of 05:00 instead of 29:00

would appreciate if you can help with this scenario as well.

Regards,
Navin