Y
Yakimoto
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
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