Date time format
 

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

Date time format
 

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

Date time format
 

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

Date time format
 

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