Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Is it possible or is there any formula, if you enter a time range,say about
9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins break time calculated in tht 9hrs? If somebody can help me, please mail me or contact me at or Thanks in advance Sikander |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
If you ask a question in a newsgroup, you get an answer in the newsgroup,
not by e-mail. Also you'll need to be clearer as to what you want. If we have to guess the question, we're not likely to be able to guess the answer as well. -- David Biddulph "Sikander" wrote in message ... Is it possible or is there any formula, if you enter a time range,say about 9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins break time calculated in tht 9hrs? If somebody can help me, please mail me or contact me at or Thanks in advance Sikander |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Thanks for the reply David, n sorry abt my statement...well, tht was my first
post or question in this community..will make sure wont repeat it again. Coming back to my question again:here is wht i need: "i need a automated formula which will give me breaks timing, for example, if am employees is working for 9hrs a day, i wnt to schedule the breaks for them,in such a way tht no 2 empolyees breaks are same,like, if 1 empolyee is on lunch break for 30mins, the other employee will go for break after other returns. In this way, i wnt to schedule breaks for 50 employees in an organization. its scheduling the breaks for all the employees in a time slot of 9hrs a day, its not only 30mins breaks, also of 2 15mins breaks too. like 2-4 employees on break at a time..no matter its 30mins or 15mins. (hope my question or requirement is clear?) Thanks "David Biddulph" wrote: If you ask a question in a newsgroup, you get an answer in the newsgroup, not by e-mail. Also you'll need to be clearer as to what you want. If we have to guess the question, we're not likely to be able to guess the answer as well. -- David Biddulph "Sikander" wrote in message ... Is it possible or is there any formula, if you enter a time range,say about 9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins break time calculated in tht 9hrs? If somebody can help me, please mail me or contact me at or Thanks in advance Sikander |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
You have 50 employees, each of whom within their 9 hour day are entitled to
one 30 minute break and two 15 minute breaks, hence a total of one hour within the 9 hours. On average, therefore, you would have 50/9 (or 5.5555) employees on a break at a time. What constraint is there on how long a gap there is between breaks (or between a break and the start or end of the day)? What constraint on what order the beaks are taken in (in other words is it always a 15 minute break in the morning, then a 30 minute in the middle of the day, then another 15 minute break in the afternoon?)? Any constraint on which employees are on a break together, or all 50 regarded as interchangeable for this purpose? Not clear what you mean by "no 2 empolyees breaks are same". Do you mean that if employee A goes for a break starting at 10:15, employee B can't go until 10:16, or until 10:15:01, or what do you mean? [You said "if 1 empolyee is on lunch break for 30mins, the other employee will go for break after other returns", but we've already established that an average of more than 5 will be on a break at the same time.] As you see, still many more questions than answers. You really need to specify the problem much more precisely before you come to the group for help. With most computing problems, it isn't the implementation of the solution that is the difficult part of the task, but the specification of the requirement. -- David Biddulph "Sikander" wrote in message ... Thanks for the reply David, n sorry abt my statement...well, tht was my first post or question in this community..will make sure wont repeat it again. Coming back to my question again:here is wht i need: "i need a automated formula which will give me breaks timing, for example, if am employees is working for 9hrs a day, i wnt to schedule the breaks for them,in such a way tht no 2 empolyees breaks are same,like, if 1 empolyee is on lunch break for 30mins, the other employee will go for break after other returns. In this way, i wnt to schedule breaks for 50 employees in an organization. its scheduling the breaks for all the employees in a time slot of 9hrs a day, its not only 30mins breaks, also of 2 15mins breaks too. like 2-4 employees on break at a time..no matter its 30mins or 15mins. (hope my question or requirement is clear?) Thanks "David Biddulph" wrote: If you ask a question in a newsgroup, you get an answer in the newsgroup, not by e-mail. Also you'll need to be clearer as to what you want. If we have to guess the question, we're not likely to be able to guess the answer as well. -- David Biddulph "Sikander" wrote in message ... Is it possible or is there any formula, if you enter a time range,say about 9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins break time calculated in tht 9hrs? If somebody can help me, please mail me or contact me at or Thanks in advance Sikander |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
David,I work at IBM,its a internal help desk,its a severice delivery based
desk,we get calls,INCOMING calls, normally. so it will difficult for employees to take a break at a same time. our desk starts at 7AM -7PM. employees logs in at a diff time,say 1st batch logs in at 7am abt 5 employees n after an hr or couple, 2nd batch of other 5-8employees...n so on. thts the peak hrs,so managing breaks r difficult,so i've come up schedule break plan,I proposed this to my manager. so hw can v schedule the breaks so tht In this way 1st batch getting the preference of brks starting 15mins-30mins-15mins breaks. so atleast 1st break after 1hr r 2hrs of login ...so time diff in 1st n 2nd employee while taking break will b 10mins ..atleast. (David,hope am clear nw,plz let me knw if any questions,i'll be glad to help answer ur questions) Thanks for your replies. "David Biddulph" wrote: You have 50 employees, each of whom within their 9 hour day are entitled to one 30 minute break and two 15 minute breaks, hence a total of one hour within the 9 hours. On average, therefore, you would have 50/9 (or 5.5555) employees on a break at a time. What constraint is there on how long a gap there is between breaks (or between a break and the start or end of the day)? What constraint on what order the beaks are taken in (in other words is it always a 15 minute break in the morning, then a 30 minute in the middle of the day, then another 15 minute break in the afternoon?)? Any constraint on which employees are on a break together, or all 50 regarded as interchangeable for this purpose? Not clear what you mean by "no 2 empolyees breaks are same". Do you mean that if employee A goes for a break starting at 10:15, employee B can't go until 10:16, or until 10:15:01, or what do you mean? [You said "if 1 empolyee is on lunch break for 30mins, the other employee will go for break after other returns", but we've already established that an average of more than 5 will be on a break at the same time.] As you see, still many more questions than answers. You really need to specify the problem much more precisely before you come to the group for help. With most computing problems, it isn't the implementation of the solution that is the difficult part of the task, but the specification of the requirement. -- David Biddulph "Sikander" wrote in message ... Thanks for the reply David, n sorry abt my statement...well, tht was my first post or question in this community..will make sure wont repeat it again. Coming back to my question again:here is wht i need: "i need a automated formula which will give me breaks timing, for example, if am employees is working for 9hrs a day, i wnt to schedule the breaks for them,in such a way tht no 2 empolyees breaks are same,like, if 1 empolyee is on lunch break for 30mins, the other employee will go for break after other returns. In this way, i wnt to schedule breaks for 50 employees in an organization. its scheduling the breaks for all the employees in a time slot of 9hrs a day, its not only 30mins breaks, also of 2 15mins breaks too. like 2-4 employees on break at a time..no matter its 30mins or 15mins. (hope my question or requirement is clear?) Thanks "David Biddulph" wrote: If you ask a question in a newsgroup, you get an answer in the newsgroup, not by e-mail. Also you'll need to be clearer as to what you want. If we have to guess the question, we're not likely to be able to guess the answer as well. -- David Biddulph "Sikander" wrote in message ... Is it possible or is there any formula, if you enter a time range,say about 9hrs in a day, u can get a desired or scheduled breaks of 30mins, 15mins break time calculated in tht 9hrs? If somebody can help me, please mail me or contact me at or Thanks in advance Sikander |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time interval worksheet function | Excel Worksheet Functions | |||
How X-ax reflect correc time interval when don't have all points | Charts and Charting in Excel | |||
Calculating time interval (some across midnight) | Excel Worksheet Functions | |||
Calculations with date time interval | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) |