Is this possible?

[sdh1607]

I'm trying to create a spreadsheet that will calcualte the working hours of staff based on their allocated shifts, so everytime the persons name is typed into a cell on the allocation sheet a calculation of the adjacent 2 cells ie 08:00 08:30 equalling 0:30 is entered onto their time sheet for a given day and week. Is this possible and if so what would be the best way to do it??

 

[scottylad2]

I'm trying to create a spreadsheet that will calcualte the working hours of staff based on their allocated shifts, so everytime the persons name is typed into a cell on the allocation sheet a calculation of the adjacent 2 cells ie 08:00 08:30 equalling 0:30 is entered onto their time sheet for a given day and week. Is this possible and if so what would be the best way to do it??

You would need to have a record of who works what hours stored in a table. Say for instance in your sample the name you enter is Dave, and he only eber works from 08:00 08:30 then in a table somewhere this would need to be recorded. THen in your time sheet you can have a Vlookup that will refer to previously entered shifts and draw the start/end times across. Is this something like what you need?

The times applicable to all the employees would need to be stored somewhere. The allocated shift times i've stored in the table named ShiftTable whick goes from K4:M9

Excel Workbook
	K	L	M	N
3		Start	End
4	Dave	08:00	08:45
5	Allan	08:45	09:30
6	Sally	09:30	11:00
7	Pete	11:00	12:45
8	Rachel	12:45	14:00
9	Simon	14:00	16:00
10
11
12	Employee	Start	End	Total
13	Rachel	12:45	14:00	1:15
Sheet1