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 |
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 |