Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Clock Intervals
I would like to input the times punched from the time clock into Excel.
(That part is no problem.) Then, I'd like Excel to round each time to its nearest 15 min. interval. Example: Brandi punches in at 8:26 - We round that up to 8:30. She then punches out at 12:22 - We round that to 12:30. She punches back in at 12:46 - Rounded to 12:45 and leaves at 5:57 - Rounded to 6:00. I can't get Excel to do the rounding part. Please help. -- Laura Walters |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Clock Intervals
XL stores times as fractional days. Since there are 24*4 quarter hours
in a day, one way: =ROUND(A1*96,0)/96 Format as time. In article , Laura wrote: I would like to input the times punched from the time clock into Excel. (That part is no problem.) Then, I'd like Excel to round each time to its nearest 15 min. interval. Example: Brandi punches in at 8:26 - We round that up to 8:30. She then punches out at 12:22 - We round that to 12:30. She punches back in at 12:46 - Rounded to 12:45 and leaves at 5:57 - Rounded to 6:00. I can't get Excel to do the rounding part. Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Clock Intervals
Laura,
You can use the MROUND function to round up or down to the nearest interval. For example, =MROUND(A1,TIME(0,15,0)) Be sure to format this cell as a time, not general or numeric. MROUND is part of the Analysis Tool Pak, so you must load this. Go to the Tools menu, choose Add Ins, and check "Analysis Tool Pak". -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Laura" wrote in message ... I would like to input the times punched from the time clock into Excel. (That part is no problem.) Then, I'd like Excel to round each time to its nearest 15 min. interval. Example: Brandi punches in at 8:26 - We round that up to 8:30. She then punches out at 12:22 - We round that to 12:30. She punches back in at 12:46 - Rounded to 12:45 and leaves at 5:57 - Rounded to 6:00. I can't get Excel to do the rounding part. Please help. -- Laura Walters |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
SUM-ing date for different time intervals | Excel Worksheet Functions | |||
Time Intervals | Excel Worksheet Functions | |||
can cell's act like time clock at a certen time/date for payments | Excel Discussion (Misc queries) | |||
Time Clock | Excel Worksheet Functions |