Time formating from hh mm ss raw format to hh mm

[teodora bocarski]

Hi, i am not able to copy times from raw exported document where time is in table as for exampe 07:52:00 and under format cella option under time section is set as 13:30:55 and location serbia latin boana and herzegovina and under custom section as hh:mm. But in formates document it should be 07:52 without seconda i tried it classicly to format cells but not successfuly. On formated documents under format cells and time is set as 13:30:55 location serbia larin bosna and hercegovina. And under cuatom aslo hh mm. But when i tried to copy data from raw documwnt and paste ro formated document time showed as 07:52:00 instead 07:52. I alao tried paste special. I am kor sure what i am doing wrong. Please help. Thanks in advance

 

[Alex Blakenburg]

I expect that @Dave Patton's answer to your other thread would have fixed this one as well.

How to change raw time data from 07:05:00 to 07:05:00 AM? Not able by format

I have tried by format cells and it was not successfuly. Tried manualy to add to 07:05:00 AM and it changed under fx as 07:05:00 AM also same in the table. Export has a lot of times so it is not easy to do it manually. Any advice? Thanks in advance

www.mrexcel.com

 

[teodora bocarski]

Yes, his response was helpfull. Thanks a lot!

 

[Alex Blakenburg]

Thanks for confirming.