View Single Post
  #1   Report Post  
Denise Robinson
 
Posts: n/a
Default Time displaying wrongly

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