Hi experts,
I have a problem using TEXT(value,format) function because of regional
settings.

Actually I need to get a Time only value from DateTime value.
So I use the following formula:
=Text(B2,"h:mm")

But I found that it doesn't work on the machines with f.ex. Danish regional
settings, because it must be "t:mm" for Danes.

How can I get rid of Date in DateTime cell?
Any help?

Thanks,
Yakimo