Formula TIME question

[Pharmagirl]

I would like to know if it's possible to convert regular time to military time in Excel. I'm importing information from another program and need to convert all times after Noon to military. Is there a formula I can use for this?

Thanks for your help.
PG

[bpeltzer]

If you've already got 3:30 PM, you can convert that to 15:30 just by
selecting the right format: Format > Cells, select the Number tab, then the
Time category. The second one down (13:30) should do what you need.

"Pharmagirl" wrote:

>
> I would like to know if it's possible to convert regular time to
> military time in Excel. I'm importing information from another program
> and need to convert all times after Noon to military. Is there a
> formula I can use for this?
>
> Thanks for your help.
> PG
>
>
> --
> Pharmagirl
> ------------------------------------------------------------------------
> Pharmagirl's Profile: http://www.excelforum.com/member.php...o&userid=20880
> View this thread: http://www.excelforum.com/showthread...hreadid=484997
>
>