Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Our office follows the seven minute rule when calculating time on our time
sheets. To make this automated time sheet I've designed work properly, I need a function that will round each time entry to the nearest quarter hour. Thus for example, 7:26 AM would need to be rounded to 7:30 AM, and 12:37 PM would need to be rounded to 12:30 PM. Once someone helps me figure that out, I have everything else that will calculate everything correctly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can i secuire Sheet Same time Update the Pivot Table | Excel Worksheet Functions | |||
TIME function used in Excel | Excel Worksheet Functions | |||
How to set up weekly time sheet with flexi time. | Excel Worksheet Functions | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |