adding time in a work schedule
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
|