Sir,
One cell has a free flow text with some inputs which is standard. Is there any way, I can pick only those standard words.
Example
Have posted to Street 1, on jan 2012 - I need to extract only street 1 to a different column.
Hi,
I have data in the format Day:hour:Minute:Sec (Example: 002:22:10:02 which means 2 days, 22 hours, 10 minutes and 02 seconds)
Need help in converting this into Hours
Thank you
Akilan
Hi,
How do I calculate time difference. This is the format in which I have the data (Given below). I need to add two criteria. 1. The clock should start at 9 AM and end at 6 PM 2. The clock should stop on Friday 6 PM and start again only on Monday at 9 AM.
01/03/2011 03:17:00 PM 07/03/2011...