I am trying to calculate the time spent by operators on the shop floor
actually working on a product. I have the start times and end times but
these times also include lunch breaks. Is there anyway in Excel I can
actually subtract the time of the lunch break.

For example if the operator works from 11:30 am to 1:30 pm I would like
to subtract 30 min from it (12:00-12:30). If the operator works from
11:00 to 12:15 and then 12:30 to 2:00 pm I would like to subtract 15
min from it (12:00-12:15) and add the remaining time (12:30 -2:00). I
have 1000 rows and doing this manually would take a lot of time as well
as be prone to errors.

Can anyone recommend some easy way to do this.............

Thanks


--
badger
------------------------------------------------------------------------
badger's Profile: http://www.excelforum.com/member.php...o&userid=24642
View this thread: http://www.excelforum.com/showthread...hreadid=382274