VBA code to consolidate data based on time

[skml]

Dear Sir,


I have attached an excel file named Timesplit.xls. The workbook contains two worksheets Rawdata and Output.

Kindly provide me a macro code in such a way that input to be taken from Rawdata and displayed in the same format mentioned in the sheet named Output.

Thanks and Regards

[skml]

Dear Sir,

Any update on this thread

Awaiting for your valuable reply

[skml]

Dear sir
Kindly help me.

[skml]

Dear Sir,

Till now no one has attended to this thread

Shall I close this thread

[skml]

Sir,

What happened

No one has responded to this tread.

Can I know the reason please

Thanks

[sintek]

Perhaps...

Please Login or Register  to view this content.

[jindon]

16.00 pm to 17.59 pm
24 hours time with am/pm?

Please Login or Register  to view this content.

[skml]

Dear Sir,

Regret for the delay in testing the code.

Now I have tested.

Time upto 10.59.59 pm the code is executed without error

If I have give time 11.00.00 pm then the code is not executing. It shows error.

I have attached excel file. In the Sheet named Rawdata in row no 10 I have given time as 11.00.00 pm

Thanks and Regards

[skml]

Mr Jindon

Thanks for the response. I have tested.

The program is not getting executed. It shows error.

I have attached macro file for your reference.

Kindly check.

Thanks and Regards

[sintek]

Try.......

[jindon]

skml,

You have not ued my code.

[skml]

Mr Sintek

tested

working fine

Thanks for the response.

[skml]

Mr Jindon

I have not copied your code properly.

Now I have tested your code

Working fine.

thanks and Regards

[Dante Amor]

Here another macro for you to consider:

Please Login or Register  to view this content.

[sintek]

Mr Sintek
tested working fine

Glad to have contributed...Tx for rep +