I went to the page you suggested and tried the tzconfig. My version of Ubuntu said:
I did that, and it here are the results.
WARNING: the tzconfig command is deprecated, please use:
That looks correct (I think) Pacific Daylight savings Time (PDT) is seven hours.
Current default time zone: 'America/Los_Angeles'
Local time is now: Fri Mar 30 23:34:41 PDT 2012.
Universal Time is now: Sat Mar 31 06:34:41 UTC 2012.
It looks like I may have made a mistake or 2 in the original report.
After thinking about what you said, I realized there are 6 permutations for making, saving, and viewing the file.
Use Ubuntu or XP to make a file.
Save the file on XP or Ubuntu.
Use Windows Explorer or Nautilus to look at the time,
I finally made an excel sheet to keep it all straight, The results are attached in a PDF and I think the link is at the bottom of this post.
I know Ubuntu sets the system computer time to GMT and converts everything as needed. I am not sure if Samba uses operating system calls to do that or if it does it itself. That would only be half the problem as Samba is a file server, not the client.
I think Windows, on the other hand, sets the system clock to the local time and changes the clock twice a year. I know there is some kind of bug as to when windows changes the time (damn government changing the dates for that, and damn government for making daylights saving time in the first place, but that is another argument.)
Anyway, I am at a loss as to how to fix this particular problem.