I am having trouble converting a text cell to a time cell. Please help as this is driving me mad! I have found several fixes online but none of them specifically address my problem.

I have time inputted as text, such as 8.40 to indicate 8 hours and 40 minutes. However, if I format the cell as a time cell, it changes the time to 9:36. This is not right. I just want it to display as 08:40. If I go 'find' and 'replace' the full stop with a colon, it doesn't work either, it returns 08:04 which is also wrong. Any help will be very much appreciated PLEASE!!!

N