A point vector layer was added to QGIS, after exporting the layer to .xlsx the coordinates in wkt format were attached to the table.
In QGis I added additional columns x and y, to assign a coordinates in DMS format to each geometry. I filled that columns with tool 'Field Calculator', with the formula:
to_dms(x(transform($geometry,'EPSG:3765','EPSG:4326')), 'x', 3) to_dms(y(transform($geometry,'EPSG:3765','EPSG:4326')), 'y', 3)
and that part works fine.
But I get the coordinates in format:
Is it possible in QGIS to get coordinates in the format:
I have solution but now I have in my format N (north) and E (east) but I expect N and W, does anyone have an idea why this is so?