Fortunately, Microsoft Excel can convert them very easily for you ... Microsoft Excel is a versatile... =A1/60 converts seconds into a decimal fraction of one minute =A1/3600 converts seconds ...

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 ...

Q. Thanks for your advice in the September 2001 issue on converting fractions in Excel into decimal values. But how about those of us who need to do the reverse—that is, convert decimal values into ...