Thread: adding time in a work schedule
View Single Post
  #2  
Old April 29th, 2010, 02:26 AM posted to microsoft.public.excel.worksheet.functions
ozgrid.com
external usenet poster
  
Posts: 328
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