Dear Senior,
Thanks for your reply & support. I'll keep this in my mind for better
future assistance.
Thanks
Ashish kumar
On Thursday, January 10, 2013 1:03:01 PM UTC+5:30, Ms-Exl-Learner wrote:
>
> Please make it in an excel workbook and send it to us for our better
> understanding of your
Dear Noorain Sir,
Thanks for your valuable support.
Thanks
Ashish Kumar
On Thursday, January 10, 2013 1:13:59 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Ashish,
>
> You can try,,
>
>
> For date
> =date(year(a1),month(a1),day(a1)
> and press ctrl+shift+#
>
> For time
> =date(Hour(a1),minute(a1)
Dear Ashish,
You can try,,
For date
=date(year(a1),month(a1),day(a1)
and press ctrl+shift+#
For time
=date(Hour(a1),minute(a1),second(a1)
and press ctrl+shift+@
On Thu, Jan 10, 2013 at 1:01 PM, kumar.ashish861
wrote:
> Dear Seniors,
>
> Pls help to seperate date & time, if both are in 1 cell.
Please make it in an excel workbook and send it to us for our better
understanding of your data structure.
On 10-01-2013 1:01 PM, kumar.ashish861 wrote:
Dear Seniors,
Pls help to seperate date & time, if both are in 1 cell.
7/11/2012 13:51
Formula req..!
Thanks in advance
Ashish k