=A1+(B1+C1)/24

where A1 is the start time, B1 the lunch hour value, C1 the shift hours

Hi Neil,

This is easiest if you keep to entering times as hours and minute
rather than trying to be lazy and entering them as decimals.
Excel will recognise times when you enter them in the 00:00 format. S
to get a sheet to add times from a start time of 09:00, all you do i
enter this time (don't forget the colon that indicates hours*:*minutes
in a cell, enter the hours (and minutes) next into the next column (e
01:30 for an hour and one half for lunch). The next cell is for th
number of hours in the day (07:00) and finally add all these up shoul
result in 17:00

Cheers
Jo