Thread: Date showing incorrect. 30:00 hrs showing 06:00
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Date showing incorrect. 30:00 hrs showing 06:00
Format the cell with [hh]:mm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"AlanStotty" wrote in message
oups.com...
Hi,

Can you help?????

When I insert 30:00 hrs it is showing as 06:00, when I check the cell
it actually showing as 01/01/1900 06:00. I have formatted the cell
to show hh:mm but still no luck.

Thanks in advance.



Reply With QuoteReply With Quote