Denver Research

General Category => ezPower => Topic started by: pedro on July 20, 2014, 02:33:07 PM

Title: US dates & Times in TimeClock
Post by: pedro 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

Title: Re: US dates & Times in TimeClock
Post by: ronaldrwl 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.

Title: Re: US dates & Times in TimeClock
Post by: pedro 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?

Title: Re: US dates & Times in TimeClock
Post by: ronaldrwl on July 28, 2014, 05:02:10 AM

Are you talking about in the "Payroll" report, the columns Start and Out?

Title: Re: US dates & Times in TimeClock
Post by: pedro on July 31, 2014, 02:49:11 PM

Yes

Title: Re: US dates & Times in TimeClock
Post by: ronaldrwl 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