View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maresa Maresa is offline
external usenet poster
 
Posts: 5
Default Nght shift allowance

sorry if this is a duplicate, but I cannot see the question I posted last
night.
I need to calculate night shift allowance between the hours 18:00 and 6:00
the shift might run from 15:00 to 23:00, the allowance is then = 5 hours, or
it might start at 05:00 to 14:00, the answer should then be 1 hour.