How to fixed date & time format conditionally

**nur2544** · 02-24-2013, 02:57 AM

If cell A1:A having text like (blank), then cell B1:B will be current date – 1 space 23:59 (example: 2/23/2013 23:39 ).
Please remember that always date & time format will be MM/DD/YYYY HH:MM
My actual data like following

Please Login or Register  to view this content.

I need to convert like below

Please Login or Register  to view this content.

I have tried something like below formula

Please Login or Register  to view this content.

**dilipandey** · 02-24-2013, 03:22 AM

Hi Nur,

Try below formula:-

Formula:

Please Login or Register  to view this content.

format at the cell as per your format... thanks.

Regards,
DILIPandey
<click on below * if this helps>

**nur2544** · 02-24-2013, 03:34 AM

Hi, dilipandey, thanks for mail, it is not correct please check below comments
"(blank)" is not actually blank, it is text(7 characters text data ), so don't treat it as blank

**SDCh** · 02-24-2013, 03:42 AM

change code dilipandey with this

Please Login or Register  to view this content.

**nur2544** · 02-24-2013, 03:43 AM

Hi, dilipandey,
I got your point, Many thanks for helping me , it is something like

Please Login or Register  to view this content.

**dilipandey** · 02-24-2013, 04:25 AM

You are welcome Nur2544... cheers

Please mark this thread as [SOLVED].. Thanks.

Regards,
DILIPandey
<click on below * if this helps>

**nur2544** · 02-24-2013, 01:39 PM

hi, SDCh thanks

How to fixed date & time format conditionally

LinkBack

Thread Tools

Rate This Thread

Display

How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Re: How to fixed date & time format conditionally

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions