Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Roster
I have asked this before but I am looking to have a spreadsheet that will
calculate the hours worked minus their meal breaks. I would like to do 2 things: 1st one is : We work more than 5 hours we need to have a 30 minute meal break, If we work more than 8 hours we have to have an hour. Can i make a macro that will calculate this automatically. part 2: Is it possible to make excel not show the results unless the work times have been inserted into cells b3 and c3. Thanks in advance Greg |
#2
|
|||
|
|||
Not sure why you need a macro. A worksheet function works fine:
=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)5/24) In article , "Greg Brow" wrote: I have asked this before but I am looking to have a spreadsheet that will calculate the hours worked minus their meal breaks. I would like to do 2 things: 1st one is : We work more than 5 hours we need to have a 30 minute meal break, If we work more than 8 hours we have to have an hour. Can i make a macro that will calculate this automatically. part 2: Is it possible to make excel not show the results unless the work times have been inserted into cells b3 and c3. Thanks in advance Greg |
#3
|
|||
|
|||
Hit send by mistake...
=IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3))) In article , JE McGimpsey wrote: Not sure why you need a macro. A worksheet function works fine: =IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)5/24) |
#4
|
|||
|
|||
<"Hit send by mistake..."
Did you mean that literally John? Do you have something on your keyboard that is "hittable?", that can initiate a "send"? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "JE McGimpsey" wrote in message ... Hit send by mistake... =IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*(((B3+C3)5/24)+((B3+C3)1/3))) In article , JE McGimpsey wrote: Not sure why you need a macro. A worksheet function works fine: =IF(COUNT(B3,C3)<2,"",B3+C3-TIME(0,30,0)*((B3+C3)5/24) |
#5
|
|||
|
|||
Of course.
In article , "RagDyer" wrote: Do you have something on your keyboard that is "hittable?", that can initiate a "send"? |
#6
|
|||
|
|||
|
#7
|
|||
|
|||
In article ,
"Don Guillett" wrote: I have one too Doesn't everyone? |
#8
|
|||
|
|||
I sold mine!
*JE McGimpsey* has posted this message: In article , "Don Guillett" wrote: I have one too Doesn't everyone? |
#9
|
|||
|
|||
Besides taking the bait, you want me to also swallow the hook?<g
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "JE McGimpsey" wrote in message ... In article , "Don Guillett" wrote: I have one too Doesn't everyone? |
#10
|
|||
|
|||
In article ,
"Ragdyer" wrote: Besides taking the bait, you want me to also swallow the hook?<g Well, I do live in the middle of some of the best fly-fishing area in the country... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
work roster with variable inputs | Excel Discussion (Misc queries) |