View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Basic DB Question Basic DB Question is offline
external usenet poster
 
Posts: 1
Default Time sheet formula?

What should the formula be for calculating the 1st break in my sheet,
based on the following shift lengths?
Hours
<4 =0 Minute
4-5 =10 Minutes
5-7 = 15 Minutes
7-10.5 = 10 Minutes
10.5= 15 Minutes

=if(c6<4,0....

Thanks in advance