View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E-QUIP E-QUIP is offline
external usenet poster
 
Posts: 12
Default calculating time

I am working in excel i want to put in a start time and an end time i want
for mon thru fri 7:00 am to 3:30 pm to be reg hours and any time before or
after to be ot I also want to add a luch column and to put in if there is a
lunch how much time was taken for lunch then i want it to calculate reg and
ot taking out a lunch if there is one taken - ANY HELP WOULD BE GREATLY
APPRECIATED