Time format change from 3.42pm to standard format 03:42 pm

**AaruJaan** · 06-04-2017, 08:19 AM

Hi,
I have issue I have time format in A1 like this: 3.42pm and I want a formula to convert that format into standard format 03:42 Pm in Cell B2

Thanks in advance.

**AlKey** · 06-04-2017, 08:27 AM

Try this

Formula:

Please Login or Register  to view this content.

Format cell B1 Custom, h:mm AM/PM

v	A	B
1	3.42pm	3:42 PM

**AaruJaan** · 06-04-2017, 08:29 AM

Thanks Alkey, 3.42am will convert into 03:42 am?

**AaruJaan** · 06-04-2017, 08:30 AM

some time in am some time in pm

**AlKey** · 06-04-2017, 08:36 AM

This one should work with PM and AM

Formula:

Please Login or Register  to view this content.

v	A	B
1	3.42pm	3:42 PM
2	4.55am	4:55 AM

Time format change from 3.42pm to standard format 03:42 pm

LinkBack

Thread Tools

Rate This Thread

Display

Time format change from 3.42pm to standard format 03:42 pm

Re: Time format change from 3.42pm to standard format 03:42 pm

Re: Time format change from 3.42pm to standard format 03:42 pm

Re: Time format change from 3.42pm to standard format 03:42 pm

Re: Time format change from 3.42pm to standard format 03:42 pm

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Converting Standard Time format (hh:mm:ss) to number of minutes

[SOLVED] help on vba code to change the error date format as standard format mm/dd/yyyy

Change format of lots of data cell to a time format

[SOLVED] How to I convert standard time to Military or 24 hour format?

[SOLVED] how do i convert standard time format into seconds?

[SOLVED] Convert data into standard military time format

[SOLVED] Working w/ non-standard Time Format

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions