Quote:
Originally Posted by xor
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.
|
thanks xor, it's working fine now. i had tried the same thing, but it wasn't working quite right. i think i was overlooking something when changing A1's to C1's.
if i wanted to move the formula down on the sheet instead of across, what would i change then to make it work?