In Excel time is a number (.5 is 12 midday) and you simply format the same
number to how you want it to appear but the underlying value doesn't change.
From the top menu...
Format>Cells>Time
Select your favorite time format.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
