Time Sheet Function

[HRMSN]

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.

[Alan]

=ROUND(A1*96,0)/96
Regards,
Alan.
"HRMSN" <[email protected]> wrote in message
news:[email protected]...
> 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.

[HRMSN]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

[Alan]

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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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.
>>
>>
>>