Help with Excel formula and Time...

N

neilcarden

Hi everyone,

I'm looking to create an excel sheet which when someone inputs a start
time eg: 09:00, time for lunch: 1 hour, and length of shift: 7 hours,
it throws up the time they are due to finish ie: 17:00 - I know this is
relatively straight forward to work out in your head, but we have a lot
of new starters and a vast array of shifts and lunchtime options so
thought this would be a useful tool...

How do I go about setting up such a spreadsheet?
Thanks in advance...

Neil
 
B

Bob Phillips

=A1+(B1+C1)/24

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
J

Jon Quixley

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
 
Top