"Peter Andrews" wrote:
I don't believe that there is such a time as 24:00!
I believe that
http://en.wikipedia.org/wiki/24-hour_clock is correct on this
point. In a nutshell, 24:00 is used and useful.
---- original message -----
"Peter Andrews" wrote in message
...
"sorab" wrote in message
...
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.
AIUI 1st May 2009 24:00 is 2nd May 2009 00:00, I don't believe that there
is such a time as 24:00! But no doubt someone with better knowledge will
correct me.
Peter