Sage 50 Payroll Upload Problem

**suma** · 02-19-2012, 05:24 PM

Hi,

I am in the process of developing an excel upload into Sage 50 Payroll, but have hit a snag.

If someone works less than their contracted hours, the upload generates a negative value.

I need excel to return a zero value instead of a negative one, without altering the original formula from working when someone goes over their hours.

I have attached a sample for your reference, and highlighted problem cells in blue. I hope someone can help.

Many Thanks,

Sue

**jetted** · 02-19-2012, 05:37 PM

In your formula

=MAX(M4-N4,0)

**suma** · 02-19-2012, 05:52 PM

Hi Denis,

That formula does not work properly.

It first must recignise the first four hours of overtime at 1/3 of time, then 1/2 of time before kikking in.

So there should be more than 33 hours worked before formula works.

Sue

**royUK** · 02-20-2012, 03:02 AM

I think you are wasting your time. I tried a similar exercise to up;oad payroll from a csv to Sage Payroll. SagePayroll advisor told me that although they say you can, it rarely works .