I have data in cells that are in the colon time format (12:28:00 AM) is what the cell reads. I want to cnvert these hh:mm:ss data to decimal hours. I can't find a function in Excell that will do that -- what is the easiest way to do this?
=TIMEVALUE() does NOT work
BTW, if I delete the "AM" from the rear of the cell 'text' then Excell just puts it back on there again...