Need Help with Microsoft Excel

bjj9126

Active Member
#1
I need help with Excel Please,

I have a time in cell A1 = 9:15:00 AM
I want to convert it in cell B1 = 091500

Please help
 

Raju

Well-Known Member
#2
=(v4-int(v4))*24
 
#8
Hi,

I have one min interval data of nse equity in .CSV format which i want to convert into 5 min interval data.


If anybody can show me the way ?

Thanking u in advance...

Regards,
Kedar
 
#10
Dear All,
Here I have attached Excel image File. I Have Copied Today's Nifty Market Movement data in this file. Data started from 7th row to 20th row.

I want to Fill Symbol name Nifty (D1 cell) from A7 to A20
I Want to Fill Date (D2 Cell) from B7 to B20 and
I want to fill Time Format (D3 Cell) C7 to C20 .

All this 3 Operation do in ONE CLICK . Any one help me?

 

Similar threads