Sean Skallerud wrote:
One of the pieces of software we use gives us time in an awkward format.
16633 means 166 minutes 33 seconds. I need a formula to convert this figure
to a decimal respresentation of time (166.55 for the example listed
previously).

Any help will be much appreciated.


One approach:

[ ] = int(a1/100) + 100*(A1/100 - int(A1/100))/60


Bill