Tech Support: 24 Hour Time Format into 12 Hour Format??

24 Hour Time Format into 12 Hour Format??

Dear All,
I have the below date format some of them are in 24 hour format and some of are in 12 hour format with AM/PM after them.
Now, i am trying to convert the times having 24 hour format like 15:30:37 PM, 14:00:00 AM etc into 12 hour format like 3:30:37 PM & 2:00:00
AM and other time values that are already in 12 hour format should remain the same.
it should only convert 24 hour time format values into 12 hour time format with AM/PM as usual.
I tried the below formula->>
 =--SUBSTITUTE(TEXT(A1,"0.00"),".",":")
But could not find the desired output.
 
15:30:37 PM
03:00:00 PM
03:15:25 AM
04:40:15 AM
23:05:45 PM
08:05:10 AM
09:00:05 PM
22:55:00 AM
11:25:00 PM
04:40:00 AM
13:35:59 PM
15:20:00 PM
13:12:00 PM
16:12:00 AM
16:47:17 PM
17:56:38 AM
12:00:00 AM
13:00:00 PM
14:00:00 AM
20:00:00 PM
21:00:00 AM
22:00:00 PM
22:10:00 AM
13.45:27 AM
17.25:00 PM
 
Regards
Dharmesh

Keys to the Problem 24 Hour Time Format into 12 Hour Format??

Download SmartPCFixer for Free Now

Hi Dharmesh,
As far as I know, 22:00 AM does not exist because it is in 24h format.
In 12h format it is 10:00 PM.
AM stands for "Ante Meridiem", "before noo"n and starts at 12:00 AM (this is midnight), 12:00 PM stands for Post Meridiem = noon.
So do not make the mistake that AM stands for After Midnight".
So the sequence in this is:
12AM, 1AM, 2AM, ....
12PM(noon), 1PM up to 11PM
Wkr,
 
 
 

If this post answers your question, please mark it as the Answer.
JP Ronse

Make Sure that your Computer Meets the System Requirements

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Fix the Problem: 24 Hour Time Format into 12 Hour Format??:

How to Fix 24 Hour Time Format into 12 Hour Format?? with SmartPCFixer?

1. Download Error Fixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related:
Read More: Troubleshoot:16 bit MS-DOS Subsystem Error,4 G Ram was installed in my computer but in system information it is written that only 3 are usable\/ Why? [Anwsered],Solution to Problem: 2 versions of windows installed on my PC. C drive and D:\Recovery drive. How can I fix this,[Solved] 2010 Word & Excel Mail Merge - URGENT,Solution to Error: 1.Click the Start button , click Control Panel, click Hardware and Sound, and then click Bluetooth Devices.,3 updates won't install and Error code 646 (KB979895, KB 978380 and KB978382),3.79 gig usable from 4 gig installed memory,25 % of usable ram cannot be used,64bit system is attempting to install 32bit updates,4.7 gb DVD-RAM disks OK, 2.6 gb will not read
Comments