Time Conversion question
 

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.

=INT(A1/100)+MOD(A1,100)*5/300

HTH. Best wishes Harald

"Sean Skallerud" skrev i melding
...
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.

Sean,

if the format is always the same then try:

=INT(A1/100)+MOD(A1,100)/100


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Sean Skallerud" wrote in message
...
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.

What I really meant of course was:

=INT(A1/100)+MOD(A1,100)/60

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Sean Skallerud" wrote in message
...
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.

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