Hello all,

I tried to find a solution for a case I'm facing, where basically I want to extract/split + count the hours of a certain cell.

As examples I have on cells:

- A1: 08:00
- A2: 06:00
- A3: 01:00
- A4: 02:00
- A5: 00:00

I always need 2 things to split the first hour, from the remaining hours and to count the total times I have 1 hours blocks.

The formulas on Bx, Cx, Dx and Ex should return these:

- B1: 01:00 / C1: 07:00 | D1: 1 / E1: 7
- B2: 01:00 / C2: 05:00 | D2: 1 / E2: 5
- B3: 01:00 / C3: 00:00 | D3: 1 / E3: 0
- B4: 01:00 / C4: 01:00 | D4: 1 / E4: 1
- B5: 00:00 / C5: 00:00 | D5: 0 / E5: 0

I already tried several formulas, but can't get one that really does what I need.

Could any of the excel masters of the forum, kindly share some possible solutions?

Very much appreciated, in advance.