One mo
=A1+TIME(0,30,0)

Regards,
Fred

"ozgrid.com" wrote in message
...
=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