View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default adding time in a work schedule

=A1+"00:30:00"



--
Regards
Dave Hawley
www.ozgrid.com
"Chris" wrote in message
...
adding time (30 minute lunch) to a time value (6 hours) that is
calculated
from two cells that contain starting time & ending time EX 6:30am-3:00pm
--
Chris