Author Topic: US dates & Times in TimeClock  (Read 5474 times)

Offline pedro

  • Newbie
  • *
  • Posts: 35
    • View Profile
US dates & Times in TimeClock
« on: July 20, 2014, 02:33:07 PM »
I like to export the timeclock data into excel when I process staff pays. From Excel I can adjust rates etc & print the payslips. BUT...the info coming from the pos program is in US date format. As I'm in Australia, Excel will not read the dates & times correctly. What to do? Do I have to change the regional settings on the sign in machine? Any ideas? Cheers

Offline ronaldrwl

  • Administrator
  • Hero Member
  • *****
  • Posts: 1676
    • View Profile
Re: US dates & Times in TimeClock
« Reply #1 on: July 21, 2014, 04:58:37 AM »
Does the date display correctly in other places in the POS program?  The date format is set by Windows in the Control Panel / Regional & Language Options.  But it may be the file export and imports are all done using the universal date format to insure consistence.

Offline pedro

  • Newbie
  • *
  • Posts: 35
    • View Profile
Re: US dates & Times in TimeClock
« Reply #2 on: July 26, 2014, 09:49:41 PM »
Inside the program, the date displays correctly.  It is only when viewing the time clock reports that the US time/date system kicks in. Is there a way to view them using the UK time format?

Offline ronaldrwl

  • Administrator
  • Hero Member
  • *****
  • Posts: 1676
    • View Profile
Re: US dates & Times in TimeClock
« Reply #3 on: July 28, 2014, 05:02:10 AM »
Are you talking about in the "Payroll" report, the columns Start and Out?

Offline pedro

  • Newbie
  • *
  • Posts: 35
    • View Profile
Re: US dates & Times in TimeClock
« Reply #4 on: July 31, 2014, 02:49:11 PM »
Yes

Offline ronaldrwl

  • Administrator
  • Hero Member
  • *****
  • Posts: 1676
    • View Profile
Re: US dates & Times in TimeClock
« Reply #5 on: August 01, 2014, 08:53:54 AM »
The start and stop dates are formatted to the setting in the Windows Control Panel.  You must be talking about something else.  It would save a lot of time for a more precise description of what you are talking about.

Employee   Start                         Out                          HH.hh   Rate   OT   HH.hh   OT Rate
PATIENCE   7/28/2014, 7:47 AM   7/28/2014, 7:49 AM   0.033   500.00/wk   0.000