Posted to microsoft.public.excel.worksheet.functions
|
|
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
|