View Single Post
  #4   Report Post  
CarlosAntenna
 
Posts: n/a
Default

When you use Anne's solution you must format the cell as a number with 2
decimal places. Try it, it works.

-- Carlos

"DaveJhelpexcel" wrote in message
...
Thanks Anne,
But the hours part is already correct it's the colon and minutes that are
the problem.

"Anne Troy" wrote:

Try this, Dave: =C22*24
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"DaveJhelpexcel" wrote in

message
...
I need to convert eg. 145:45 to decimal Hrs. (145.75) the Hrs. in the

cells
are captured from another system that I have no control over.

Thanks in advance
DaveJhelpexcel