Thread: Help: Trying to get hours for 11pm-7am shift
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caramon6561 Caramon6561 is offline
external usenet poster
  
Posts: 5
Default Help: Trying to get hours for 11pm-7am shift
I have a third shift and using excel to calculate time 10:30 to 7am all the
other shifts calculate fine useing =sum((A6-A5)*24(A4-A3)*24), But useing
this formula the third shift comes out in negative numbers any suggestions.
Reply With QuoteReply With Quote