View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default how to determine duration of meal break in timesheet (workingwith times)

On Sep 7, 6:02*am, Max wrote:
In a timesheet if a person works for fewer than five hours there is no
meal break.
Five hours or more the break is 30 minutes.
Six hours or more and the break is 45 minutes.

In this timesheet the times are entered in [h]:mm.



http://www.cpearson.com/excel/overtime.htm