rounding time
 

I'm trying to create an easy way to round a person's log in/ log out
times...

For instance, if they log in between 8am and 8:07, it rounds down to 8:00.
If it's between 8:08 and 8:15, it rounds to 8:15.

8:17 rounds to 8:15, 8:23 would round to 8:30...

So I only need the minutes to round to the quarter hour.

It gets very complicated and my brain freezes ;) What can I say? Any help?

TIA,
Mary

rounding time
 

Hi,
if you have Analysis Toolpak installed then you can use:

=MROUND(A2,15/1440)

HTH
Kostis Vezerides

On Feb 26, 7:43 pm, "MEH" wrote:
I'm trying to create an easy way to round a person's log in/ log out
times...

For instance, if they log in between 8am and 8:07, it rounds down to 8:00.
If it's between 8:08 and 8:15, it rounds to 8:15.

8:17 rounds to 8:15, 8:23 would round to 8:30...

So I only need the minutes to round to the quarter hour.

It gets very complicated and my brain freezes ;) What can I say? Any help?

TIA,
Mary

rounding time
 

One way:

=ROUND(A1*96,0)/96

(Format the cell as time)

In article ,
"MEH" wrote:

I'm trying to create an easy way to round a person's log in/ log out
times...

For instance, if they log in between 8am and 8:07, it rounds down to 8:00.
If it's between 8:08 and 8:15, it rounds to 8:15.

8:17 rounds to 8:15, 8:23 would round to 8:30...

So I only need the minutes to round to the quarter hour.

It gets very complicated and my brain freezes ;) What can I say? Any help?

TIA,
Mary

rounding time
 

"JE McGimpsey" wrote in message
...
One way:

=ROUND(A1*96,0)/96

(Format the cell as time)

In article ,
"MEH" wrote:

I'm trying to create an easy way to round a person's log in/ log out
times...

For instance, if they log in between 8am and 8:07, it rounds down to
8:00.
If it's between 8:08 and 8:15, it rounds to 8:15.

8:17 rounds to 8:15, 8:23 would round to 8:30...

So I only need the minutes to round to the quarter hour.

It gets very complicated and my brain freezes ;) What can I say? Any
help?

TIA,
Mary

OK - my brain is impressed and still doesn't realize how this works, nor
does it care.

:) Thanks SO much.