Convert time to decimals
Or as Asser suggested, just use this and format as General
Or this one from Robert Zimmer
This version of his will work with seconds if formatted as General
As will this one
Round time up to 15 minute increments
Another one of Asser's alternatives
This version from Andrew Hunt simply rounds up and down (Make sure the
Analysis Tool Pak is installed)
Show time as 1 - 12 regardless of AM or PM
Yet another version from Asser