What happens if you enter it s 6:30 (note the colon)?

Regards,
A

"Denise Robinson" wrote:

Hi all
When I enter 6.30 in a cell to indicate 6.30am the display has changed to
7.12am?

I have gone to the format time menu and keep changing it to the various
types on offer but still it comes up as 7.12?

I have tried other times and the same thing happens, 11.20 appears as
4.48!!!!

My computer time and date settings are ok, can anyone suggest why this is
happening please?

Otherwise I will just have to continue using general numbers in the
formatting.

Thank you
Denise