Microsoft Office Forums - View Single Post - extract time from a cell and move it to front of cell before text

Thread: extract time from a cell and move it to front of cell before text

View Single Post

Old

03-18-2017, 01:40 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

I use Danish settings.

"tt:mm" because hours in Danish is "timer". You should change "tt:mm" in the formula to "hh:mm"

I would have expected that Excel automatically would change "tt" to "hh", when opened on a system with US settings, but apparently not.

Reply With Quote