Please help with 03/01@0116 format

[Mvirone81]

Hello,

I can't find a way to modify this date and time format: 03/01@0116
In two cells date and time

Thank you so much,

Mauri

p.s. I couldn't find any other thread about this

 

[pgc01]

Hi
Welcome to the board

Your question is very vague. You should explain clearly what you need.

03/01@0116

What is 03/01? is it day/month or month/day?
The 0116, is it 01 hours and 16 minutes?
What is the year, is it the current year when the formula is calculated or some fixed year like 2016?

Please be specific.

 

[marcelocbd]

Hello,

I can't find a way to modify this date and time format: 03/01@0116
In two cells date and time

Thank you so much,

Mauri

p.s. I couldn't find any other thread about this

Do In the cells you want

Range("[COLOR="#FF0000"][/COLOR][COLOR="#FF0000"]Where you want date cell to be[/COLOR]").Value = Format(Range("[COLOR="#FF0000"][/COLOR][COLOR="#FF0000"]Where is your data[/COLOR]"), "dd/mm")
Range("[COLOR="#FF0000"]Where you want time cell to be[/COLOR]").Value = Format(Range("[COLOR="#FF0000"]Where is your data[/COLOR]"), "HH:nn")

If you use 12-hour system, add AM/PM inside the quotation marks after "HH:nn"

 

[FormR]

p.s. I couldn't find any other thread about this

What about this one

http://www.mrexcel.com/forum/excel-...date@time-format-please-help.html#post4392857

 

[Special-K99]

What about this one

http://www.mrexcel.com/forum/excel-...date@time-format-please-help.html#post4392857

I'm not sure what I found more interesting in that thread, the solution or the banter between Jonmo1 and Sektor (though I side with Jonmo1).