View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Maresa Maresa is offline
external usenet poster
 
Posts: 5
Default Calculate a value between 2 times

we pay a nightshift allowance between 18:00 and 6:00.
I have a timesheet with start and end times.
Say the shift started at 15:00 and ended at 23:00, I need an answer of 5,
or if the shift started at 04:30 and ended at 12:00 I need an answer of 1.5
thanks