Different Computers = Differing Returns

Hi MarvinP.

We live in the same building (a block of units) and thus have been able to compare our computers' setting.

My computer is set to 24 hr display, and I will check the other computer when I can gain access to it.

I like the polar bear conundrum...

mgs

Originally Posted by MarvinP

Hi mgs,

Are you both in the same time zone? Today() is relative to the date and time settings of your local region.

This reminds me of the joke where you have a home where all windows point south. A bear walks by. What color is the bear. (White - because if all 4 windows point south, you live at the north pole.)

Another answer might be you have different displays of the time. One is using 12 hr and the other is 24 hr display.

Hi MarvinP.

I managed to get to the other computer, and made 3 adjustments (to its Date & Time formats).

All are now identical (as per the attached Word document).

I re-sent the worksheet (as an email attachment) and everything is now working fine.

"Thanks for your help."

Cheers,
mgs

Originally Posted by MarvinP

Hi mgs,

Are you both in the same time zone? Today() is relative to the date and time settings of your local region.

This reminds me of the joke where you have a home where all windows point south. A bear walks by. What color is the bear. (White - because if all 4 windows point south, you live at the north pole.)

Another answer might be you have different displays of the time. One is using 12 hr and the other is 24 hr display.