I am trying to calculate (using worksheet formula based solution only) individual time-durations and total time duration from the slash '/' separated time-texts in two cells (each value of first cell are time-from and corresponding values in the second cell are time-to) in Excel (still using Excel 2007 only)

Input cells (B1 contains times-from data, however B2 contains corresponding times-to data)

```
Cell-B1: "00:20 / 00:58 / 09:25 / 12:05 / 17:26 / 21:58"
Cell-B2: "00:45 / 07:57 / 11:41 / 15:57 / 21:27 / 23:48"
```

Expected Output (B6 to show individual time duration, and cell B7 to show grand total of all durations)

```
Cell-B6: "00:25 / 06:59 / 02:16 / 03:52 / 04:01 / 01:50"
Cell-B7: 19:23:00
```

The data organized and expected output results are as shown in below snapshot image.

SNAPSHOT IMG: View my input data cells, and expected output data cells

I understand, VBA can do it easily and I do have basic VBA knowledge, however is there a possible single formula (may or may not be array formula) based solution to show individual time-duration and sum of the all the calculated time-duration? I simply want to avoid VBA Macros and also do not want manual process of Text To Column (using delimiter '/') then do individual time-duration calculation, and then finally show all the duration in joined form, and show the grand total of all individual time-durations.

To arrive the results, only few basic worksheet functions may only be used such as MID, FIND, SUM, SEARCH, TRIM, SUBSTITUTE, INDEX, ROW etc.