Date time format

's Computer Specifications

I have a situation in which i have lot of excel files in a folder. All with
same formats. All of them have time column in column B.

In some of the sheets data is filled in the fomrat (01/01/1900 09:00:00)
and in some of them it is in (09:00) format.

I need to bring all of them into similar formmat (09:00).

I need to do this because i change the time into values and then run another
macro which bring required data for me.

please help with any ideas codes to colve this.

Thanks!
Boss

's Computer Specifications

Columns("B:B").NumberFormat = "h:mm;@"
probably solves your problem.

Regards,
Stefi

â€žBossâ€ ezt Ã*rta:

> I have a situation in which i have lot of excel files in a folder. All with
> same formats. All of them have time column in column B.
>
> In some of the sheets data is filled in the fomrat (01/01/1900 09:00:00)
> and in some of them it is in (09:00) format.
>
> I need to bring all of them into similar formmat (09:00).
>
> I need to do this because i change the time into values and then run another
> macro which bring required data for me.
>
> please help with any ideas codes to colve this.
>
> Thanks!
> Boss

's Computer Specifications

Thanks Stefi
Boss

"Stefi" wrote:

> Columns("B:B").NumberFormat = "h:mm;@"
> probably solves your problem.
>
> Regards,
> Stefi
>
> â€žBossâ€ ezt Ã*rta:
>
> > I have a situation in which i have lot of excel files in a folder. All with
> > same formats. All of them have time column in column B.
> >
> > In some of the sheets data is filled in the fomrat (01/01/1900 09:00:00)
> > and in some of them it is in (09:00) format.
> >
> > I need to bring all of them into similar formmat (09:00).
> >
> > I need to do this because i change the time into values and then run another
> > macro which bring required data for me.
> >
> > please help with any ideas codes to colve this.
> >
> > Thanks!
> > Boss

's Computer Specifications

You are welcome! Thanks for the feedback!
Stefi
Clicking the YES button will be appreciated.

â€žBossâ€ ezt Ã*rta:

> Thanks Stefi
> Boss
>
> "Stefi" wrote:
>
> > Columns("B:B").NumberFormat = "h:mm;@"
> > probably solves your problem.
> >
> > Regards,
> > Stefi
> >
> > â€žBossâ€ ezt Ã*rta:
> >
> > > I have a situation in which i have lot of excel files in a folder. All with
> > > same formats. All of them have time column in column B.
> > >
> > > In some of the sheets data is filled in the fomrat (01/01/1900 09:00:00)
> > > and in some of them it is in (09:00) format.
> > >
> > > I need to bring all of them into similar formmat (09:00).
> > >
> > > I need to do this because i change the time into values and then run another
> > > macro which bring required data for me.
> > >
> > > please help with any ideas codes to colve this.
> > >
> > > Thanks!
> > > Boss

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting text format of time/date into Excel time/date for subtr	YY san.	Microsoft Excel Worksheet Functions	5	25th Feb 2010 07:13 AM
Convert date + time text format to date format	=?Utf-8?B?UGF1bCBIbw==?=	Microsoft Excel Worksheet Functions	2	22nd May 2007 05:47 PM
Convert a latebinded DataTable column's format from DateTime to string (or format the date time value)	RSH	Microsoft VB .NET	0	6th Dec 2006 03:49 PM
Export Outlook date field as date/time format to Access database	=?Utf-8?B?QmVja3k=?=	Microsoft Outlook Discussion	0	2nd Dec 2004 02:49 PM
Converting Date Time format to Month YEar format	Prashant Sisodia	Microsoft Excel Worksheet Functions	1	11th Jun 2004 03:56 PM