Creating an Automated Timesheet

[EdwardSnowden]

I hope you are all having a good day. I am trying to create an automated timesheet that rounds hours to the nearest quarter hour increment. Do you have any suggestions?

[Billy Spivy]

Try this formula (total hours in A1):


=CEILING(A1,0.25)

[EdwardSnowden]

Try this formula (total hours in A1):


=CEILING(A1,0.25)

Billy, thank you so much. However, it seems to be rounding up. Do you know how to make sure it rounds to the nearest .25 increment?

[Billy Spivy]

Try:

=MROUND(A1,0.25)

[EdwardSnowden]

Try:

=MROUND(A1,0.25)

Billy, this worked. Thank you so much!!!

[Billy Spivy]

Very welcome glad to help.