Get time from populated cells

[~TaC~]

Hi,

New to the forum and novice in Excel.

I have a sheet where I can fill in the times that colleagues work each day, this varies from day to day.

7-8	8-9	9-10	10-11	11-12	12-1	1-2	2-3	3-4	4-5	Start	Finish
		*	*	*	*
				*	*	*	*

<tbody>
</tbody>

What I would like is for the start and finish times to be auto populated showing first row start=09:00 and finish=13:00, second row start=11 and finish=15:00

I can't upload a picture of what I have done but the cells don't fill with * they are colour filled depending on hours worked.

How is this possible, I was hoping to use formula but now wondering if I need to use macro.

 

[~TaC~]

Yes sorry about that, as I said at the start I'm novice at excel so what I've done so far I'm quite proud of but I needed help. Its not until I started doing more than I expected that I realised it wasn't exactly what I needed.

Had to adjust +($J2>=7)* to +($J2>=6.5)* in the second formula for in to work in my situation but you've help me see how things work in excel.

Again thanks for your help and see you in my next post

 

[Tetra201]

You are welcome.