Thread: I need to calculate hours worked from 11pm to 7am minus a lunch
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paula Brooks Paula Brooks is offline
external usenet poster
  
Posts: 1
Default I need to calculate hours worked from 11pm to 7am minus a lunch
Hours worked is 11pm to 7am. Need a formula to calculate total hours worked
minus the 30 minute break if worked over 6 hours over the midnight hours.

Used IF((C41-B41)*246,(C41-B41)*24-0.5,(C41-B41)*24) were B41=7am and
C41=3pm. This works then but not with the 11pm to 7am timeframe.
--
Paula
Reply With QuoteReply With Quote