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