Get hours from a cell - count hours

[nupema]

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.

[dohvakin123]

have you tried doing "=HOUR(A1)" then formatting that cell as general

[KOKOSEK]

	a	b	c	d	e
1	08:00	01:00	07:00	1	7
2	06:00	01:00	05:00	1	5
3	01:00	01:00	00:00	1	0
4	02:00	01:00	01:00	1	1
5	00:00	00:00	00:00	0	0

	a	b	c	d	e
1	08:00	=if(a1>0,timevalue("01:00:00"),0)	=a1-b1	=b1*24	=c1*24