View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
acetoolguy acetoolguy is offline
external usenet poster
 
Posts: 4
Default lunch break!! well..how to figure

I was a row that looks this..

Arrival Departure Lunch total hours
7:00 am 5:00 pm .5 9.5

I cant seem to get the 1/2 hour lunch to deduct. I have 5 pm - 7am =10 ok

Its a line on an invoice so it also needs to be clear, no military time for
example.
Thanks for any help...