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.
<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.
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.