View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] twox4s@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 8
Default Mathematical Time Conversion Formula

Stacy:

This was a bit tougher than I thought but this formula does the
trick....

=SUM(ROUNDDOWN(_100ths,0))+ROUND(SUM(_100ths,-SUM(ROUNDDOWN(_100ths,0)))*0.6,2)

I like to use Named Ranges in Big Formulas, they make more sense.
If you simply enter "A1" wherever you see "_100ths" then this will
solve your quandry...Mark