Round result of sum function to quarter hour

[Trudy]

How can I round the result to the nearest quarter hour?

=SUM(C1414)*24

 

[T. Valko]

Try this:

=ROUND((SUM(C1414)*24)/0.25,0)*0.25

 

[Trudy]

PERFECT!!!!!!!

THANK YOU!

Try this:

=ROUND((SUM(C1414)*24)/0.25,0)*0.25

 

[T. Valko]

You're welcome. Thanks for the feedback!