Sorry, that was in my 2nd post
"I want to display the actual hours, as in 27.5 for example
Presently, the format of the cell is custom [h]:mm:ss but I do not want to touch the format of the cell..."
And yes, that was a typo. It should be 06/01/1900 6:42:19AM :)
And thank you, it worked...I...