Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Time? | Excel Worksheet Functions | |||
Time rounding help | Excel Discussion (Misc queries) | |||
Rounding Time | Excel Discussion (Misc queries) | |||
Rounding Time? | Charts and Charting in Excel | |||
Rounding of Time | Excel Worksheet Functions |