excel formating
 

How do I convert military time to reg on a spreed sheet?

excel formating
 

Hi,

Simply change the format.

Format|Cells
Select Time and the format you want

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.

Mike

"amber" wrote:

How do I convert military time to reg on a spreed sheet?

excel formating
 

From the top menu...
FormatCellsTime
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


"amber" wrote:

How do I convert military time to reg on a spreed sheet?