I currently have a total number of hours worked that I want to round to the next quarter hour. I don't want it to round back to the last quarter hour but forward. For example, even if I have a total time of 10.01 hours I would like it to round to 10.25 hours. I currently have this formula loaded in the total cell: =ROUNDUP(SUM(D6:D21),1) I also want to show the total number of hours and minutes in my total cell and not the decimal. I have attached a copy of the spreadsheet I am working with. Can anyone help me! Thanks,
Bookmarks