View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Phillips Dave Phillips is offline
external usenet poster
 
Posts: 1
Default How do I perform time calculation formuals in excel

I am trying to set up a timesheet on excel. I would like to add the hours
worked between a start and completion time, deduct the value taken for luch
(shown as time out and a time back in) from that total and then show any
hours above a 7 hour shift i.e overtime.