Thread: How can I calculate daily hours worked minus lunch to eual a decim
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How can I calculate daily hours worked minus lunch to eual a decim
Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time


=((D2-A2)-(C2-B2))*24

"lili" wrote:

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25
Reply With QuoteReply With Quote