Hi!

Hmmm....

If you want to round up to the next increment of 15, how
would you handle 30 mins? 15 mins?

The general formula to roundup to the next increment of 15
would be:

=ROUNDUP(number/15,0)*15

Values like 45, 30, 15 would not round since they are
already multiples of 15.

So, if you round 45 mins up to an hour, what do you do
with 30 mins? Round it up to 45 mins?

Need more detail.

Biff

-----Original Message-----
I need to create a time sheet whereas I can insert the
amount of time worked
on a particular issue and have it add up..the catch is
that it has to be
rounded off to the highest 1/4 hour.

For example,

Time worked: 45 minutes

Rounded off to : 1 hour

Thank you.


.

P.S. -

Also, it depends on what type of time/number format you
are using.

The formula I posted is based on decimal values and not
time formats.

Biff

-----Original Message-----
Hi!

Hmmm....

If you want to round up to the next increment of 15, how
would you handle 30 mins? 15 mins?

The general formula to roundup to the next increment of
15
would be:

=ROUNDUP(number/15,0)*15

Values like 45, 30, 15 would not round since they are
already multiples of 15.

So, if you round 45 mins up to an hour, what do you do
with 30 mins? Round it up to 45 mins?

Need more detail.

Biff

-----Original Message-----
I need to create a time sheet whereas I can insert the
amount of time worked
on a particular issue and have it add up..the catch is
that it has to be
rounded off to the highest 1/4 hour.

For example,

Time worked: 45 minutes

Rounded off to : 1 hour

Thank you.


.

.