View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andy Bolger Andy Bolger is offline
external usenet poster
 
Posts: 8
Default timesheet and overtime formula/s

Col D5: Start time
Col E5: Finish time
Col F5: Ordinary Hours

Above are all worked out, my problem is in calculating overtime
automatically and placing in:

Col H5: I want time and a half (first 3 hours)
Col I5: I want double time (after first 3 hours)

Many thanks