Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Sheet Function
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. |
#2
|
|||
|
|||
=ROUND(A1*96,0)/96
Regards, Alan. "HRMSN" wrote in message ... 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. |
#3
|
|||
|
|||
I put this formula in, but in a cell where nothing was written it came up
12:00am. What do I add to the formula below, to keep it from putting anything there if no time is entered? "Alan" wrote: =ROUND(A1*96,0)/96 Regards, Alan. "HRMSN" wrote in message ... 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. |
#4
|
|||
|
|||
That's because no value in the cell returns a zero value.
Try =IF(A1<0,ROUND(A1*96,0)/96,"") or =IF(A1<0,ROUND(A1*96,0)/96,0) in the latter, go Tools Options View and uncheck 'Zero Values' Obviously I don't know the rest of your formulas, but usually a zero value in a range that a formula applies to wont affect the result, Regards, Alan. "HRMSN" wrote in message ... I put this formula in, but in a cell where nothing was written it came up 12:00am. What do I add to the formula below, to keep it from putting anything there if no time is entered? "Alan" wrote: =ROUND(A1*96,0)/96 Regards, Alan. "HRMSN" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |