Thread: I need to calculate hours worked from 11pm to 7am minus a lunch
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default I need to calculate hours worked from 11pm to 7am minus a lunch
You may wish to try replacing each instance of (C41-B41) with MOD(C41-B41,1)
--
David Biddulph

"Paula Brooks" wrote in message
...
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