View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
neilcarden
 
Posts: n/a
Default Help with Excel formula and Time...


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


--
neilcarden
------------------------------------------------------------------------
neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623
View this thread: http://www.excelforum.com/showthread...hreadid=554029