In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data. Using a quick equation, you can convert an existing set of time ...

The time value 5:11:30 PM is 30 seconds into the minute. The decimal value .693 is 55 seconds into the minute. Internally, Excel stores the time as a decimal value. The quickest way to see that ...