Thread: 24 hr format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sorab sorab is offline
external usenet poster
 
Posts: 7
Default 24 hr format

I'm still stuck. Any advise pls.. I need my cell to be formatted to
show a date and time in 24hr format eg it should show me 1-may-09
24:00 , but I keep getting it as 2-may-09 00:00 . I know its the
same but I do want it to show me as 24:00.... is this possible in
excel. thks in advance.