Thread: rounding time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MEH MEH is offline
external usenet poster
 
Posts: 2
Default 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