View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danedel Danedel is offline
external usenet poster
 
Posts: 1
Default Calculate hours worked minus a half hour for lunch

I'm trying to find the formula to calculate the employee hours worked in a
given day allowing for a half hour lunch. The time card entry looks like:

Time in: 6:00
Time out: 14:30
I want the answer to be 8