Summing and Rounding Time Worked

[OverKnight]

I’m creating a simple time sheet (attached) and I need to sum the time worked in each pay period and round this value to the nearest 15 minutes. My attempt at this is in cell O10, with this formula: ROUND((SUM(E12:N12)*24)/0.25,0)*0.25. As you can see, it’s not working. Can someone help solve this?

Thank you.

[Tony Valko]

Try it like this...

=ROUND(SUM(E12:N12)*96,0)/96

Format as [h]:mm

[OverKnight]

Thank you, Tony, this works perfectly.

[Tony Valko]

You're welcome. Thanks for the feedback!