| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time sheet formula?
You need to look at the logic of your question, For example 5 could return
either 10 or 15 and likewise 10.5 could return two values. On the assumption you don't mean this try. =IF(C6<=4,0,IF(C6<=5,10,IF(C6<=7,15,IF(C6<=10.5,10 ,15)))) "Basic DB Question" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time sheet formula?
Are these values cumulative? If so, one way:
=LOOKUP(C6,{0,0;4,10;5,25;7,35;10.5,50}) In article .com, "Basic DB Question" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
| Excel formula for a time sheet | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
Linear Mode
