Thank you very much for your answer. But I am also very new to this and was wondering if you could go into more detail. I'm not sure how this will accomplish what I need. What I need is for the Pay Period Begining (Named PPBegin) date to be entered manualy. Then the Pay Period End date to be automat...

I'm creating a timesheet and I'm trying to streamline it to make it easier to fill out. What I need FormCalc to do is calculate the pay period and auto-fill the Dates columns. So all the user will need to do is fill out the begining date of the pay period and then have rest be filled out automatical...

This works perfectly. Thank you for your time, I hope that it wasn't much trouble. Now I have one last question and I just want to know if it's possible I can look into on to do it on my own. But is there a way to have it setup so that when they enter in the "Pay Period Beginning" and "Ending" date ...

It liked that one, but its not adding up right. If I put that I was in at 09:00 and out at 10:00 it shows 0 hours worked, but if I put in at 09:30 and out at 10:00 it shows -14.5 hours worked, and if i put in at 09:00 and out at 10:30 it shows 15.5 hours worked.

You should be getting the e

It's set to FormCalc, thanks for the reply.

Thanks a lot, this looks like what I need. But I'm new to FormCalc and this a little too advance for me. I tried plugging this into my timesheet and I get an error:Script failed (language is formcalc; contect isxfa[0].form[0].topmostSubform[0].Page1[0].HW1[0])script=...Error: syntax error near token...

Thanks for the reply, any idea on how to do quarter hour rounding in FormCalc than?

I got this solution from another forum, but because I know nothing about JavaScript it makes no sense to me. Would this be able to work for me? If so, could you explain how this script works? Thanks Derrick.function TimeDiff(cInName, cOutName) {// Using a time format of 'h:MM tt' for the start and e...

I have this time sheet that has four "In" and four "Out" columns,and calculates hours worked in a two week pay period. There is a column on the right that calculates the hours worked for the day (see script below). I need it to round to the nearest quarter hour i.e.,If an employee arrives or leaves ...