View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZoeMarshall ZoeMarshall is offline
external usenet poster
 
Posts: 1
Default How to subtract a lunch break from total hrs worked in timesheet

I am setting up a time sheet in excel. For each day of the week, the end user
enters Time in and Time out. GA has a 30 min lunch break that I need to
subtract out of the total time for the day. I would like the end user to be
able to insert more that 30 mins if necessary.
I've checked the templates on the MS web, but none subtract a time.
Thanks,
Zoe Marshall