Calculating working hours
 

I need a formula that will calculate working hours taking into consideration
that time should be calculated every 15 minutes. For example, if someone has
worked 1 h 20, he will be paid for 1 h 15. Thanks in advance for your help.
--
Sarah

Use the numerous examples you can find in the newsgroups, then round the
result to 1/96 with a formula something like

=ROUND(TimeWorked*96,0)/96

The time worked should be an Excel time, which is a fraction of a day.

On Sun, 6 Mar 2005 13:47:04 -0800, "Sarah"
wrote:

I need a formula that will calculate working hours taking into consideration
that time should be calculated every 15 minutes. For example, if someone has
worked 1 h 20, he will be paid for 1 h 15. Thanks in advance for your help.

it partially works...except for the example below :
Time in : 8:00 (A1 cell)
Time out: 9:23(B1 cell)
Round((B1-A1)*96,0)/96
The answer should be 1:15 instead of 1:30

The same thing for 8:00 (time in) and 9:38 (time out) and so on. Round is
no good. There must be another formula other than Round, MRound, etc. Can
you try again...I need your help!

"Myrna Larson" wrote:

Use the numerous examples you can find in the newsgroups, then round the
result to 1/96 with a formula something like

=ROUND(TimeWorked*96,0)/96

The time worked should be an Excel time, which is a fraction of a day.

On Sun, 6 Mar 2005 13:47:04 -0800, "Sarah"
wrote:

I need a formula that will calculate working hours taking into consideration
that time should be calculated every 15 minutes. For example, if someone has
worked 1 h 20, he will be paid for 1 h 15. Thanks in advance for your help.

In the example you show, the person worked 8 minutes of the next quarter hour,
which is more than half of that quarter hour. If that is not to be rounded up,
then what are your rounding rules? How many minutes must the person work in
order to round UP to a full 15 minutes?


On Sun, 13 Mar 2005 13:15:02 -0800, "Sarah"
wrote:

it partially works...except for the example below :
Time in : 8:00 (A1 cell)
Time out: 9:23(B1 cell)
Round((B1-A1)*96,0)/96
The answer should be 1:15 instead of 1:30

The same thing for 8:00 (time in) and 9:38 (time out) and so on. Round is
no good. There must be another formula other than Round, MRound, etc. Can
you try again...I need your help!

"Myrna Larson" wrote:

Use the numerous examples you can find in the newsgroups, then round the
result to 1/96 with a formula something like

=ROUND(TimeWorked*96,0)/96

The time worked should be an Excel time, which is a fraction of a day.

On Sun, 6 Mar 2005 13:47:04 -0800, "Sarah"

wrote:

I need a formula that will calculate working hours taking into
consideration
that time should be calculated every 15 minutes. For example, if someone
has
worked 1 h 20, he will be paid for 1 h 15. Thanks in advance for your
help.