Hi Chris

With start time in cell A1 and end time in cell B1

In cell C1 apply the below formula and format the formula cell to custom
format [h]:mm

=(B1-A1)+(0.5/24)

--
Jacob (MVP - Excel)


"Chris" wrote:

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