Total pending time duration conversion.
Column A1 is Order date, Column B1 Success date, Column C1 duration (duration format is hh:mm:ss) and Column D1 is the total pending time.
Example:
Column A1 (10/3/2023 14:52:14), Column B1 (10/4/2023 16:08:00), using the formula (=B1-A1) in Column C...