Thread
:
Time Conversion question
View Single Post
#
4
Sandy Mann
Posts: n/a
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.
Reply With Quote