Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default time interval calculation

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,651
Default time interval calculation

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default time interval calculation

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,651
Default time interval calculation

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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default time interval calculation

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time interval worksheet function Zb Kornecki Excel Worksheet Functions 3 March 13th 07 07:33 PM
How X-ax reflect correc time interval when don't have all points Narges Charts and Charting in Excel 1 April 12th 06 04:00 PM
Calculating time interval (some across midnight) [email protected] Excel Worksheet Functions 3 January 17th 06 05:50 PM
Calculations with date time interval Todd F. Excel Worksheet Functions 6 September 22nd 05 07:43 PM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"