Date/Time Calculations

[joflo723]

Date/Time Calculating in Livecycle is one skill that I have yet to master! I have developed a time sheet with punch in/out buttons, and I think the calculations are working correctly, but the trouble I am forseeing is that the calculations are based on times only, not on dates AND times. Consequently, if someone punches IN on Jan 1 2014 at 08:00AM and punches OUT at 09:00AM on Jan 2 2014, it calculates 1 hour, instead of correctly calculating 25 hours. This would, in essence, create a way for an employee to be dishonest in their timekeeping. Is there a way to calculate this correctly? I am attaching the form for reference.

Thanks!

Jo

https://files.acrobat.com/preview/1396254a-d517-4666-a171-94b2cb0aa60b

[Former Community Member]

I get "This Webpage is not available" when clicking on your link. 

The webpage at https://files.acrobat.com/preview/1396254a-d517-4666-a171-94b2cb0aa60b might be temporarily down or it may have moved permanently to a new web address.

Error code: ERR_TUNNEL_CONNECTION_FAILED

[joflo723]

Working for me. The "temporarily down" must have been the issue.

Anyone care to have a go at this?

Jo

[joflo723]

Bumping this up because I still haven't figured this out. I would very much appreciate some time/date calculation experts helping me on this one.

Thanks.

Jo