Decimal Time

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


© Copyright All Rights Reserved.