83500 PM i want change timings 12hrs to 24 hrs but i can't able to change above mentioned timings kindly help me out on this
When you work on Excel in your daily work, you may use different time format under different conditions, such as 12 hour format and 24 hour format as following screenshot shown. But, how could you convert time format from 12 hour to 24 hour and vice versa in Excel?
Convert time to hours / minutes / seconds:
Kutools for Excel's Convert Time feature can help you to convert multiple time format to hours, minutes or seconds as you wanted. Click to download and free trial Kutools for Excel now!
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
The following formulas can help you to convert the time format from 12 hour to 24 hour and vice versa.
Convert time format from 12 hour to 24 hour:
Please enter this formula: =TEXT(A2,"[hh]:mm:ss") into a blank cell where you want to output the result, and then drag the fill handle down to the cells that you want to apply this formula, and all the time format has been converted from 12 hour to 24 hour, see screenshot:
Convert time format from 24 hour to 12 hour:
To convert the time format from 24 hour to 12 hour, please type this formula: =TEXT(A2,"hh:mm:ss AM/PM") into a blank cell to locate the result, and drag the fill handle down to the cells that you want to contain this formula, and all the 24 hour time format cells have been converted to 12 hour format, see screenshot: