Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula TIME question
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 |
#2
|
|||
|
|||
Formula TIME question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the formula to display a negative time results? | Excel Worksheet Functions | |||
An Excel Formula Question | Excel Worksheet Functions | |||
Time Elapse Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
rounding time question | Excel Worksheet Functions |