Home> Reporting > Reporting Date and Time Calculation

Reporting Date and Time Calculation

Add a topic

Home › Forum › Reporting › Reporting Date and Time Calculation

This topic contains 3 replies, has 2 voices, and was last updated by  Dennis @ PerfectForms 5 years, 6 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • April 9, 2014 at 10:58 am #7058

    gblanken
    Participant

    I have a created a time off request form and report. I would like my report to show the total minutes, hours, and days using the beginning date/time and ending date/time from the form. Any help would be appreciated.

    Thanks

    April 9, 2014 at 11:04 am #7063

    Dennis @ PerfectForms
    Blocked

    I have built a sample form to demonstrate the behavior. It is a bit complex. I will email you the sample form. Import it into your account to review the behavior.

    April 11, 2014 at 7:55 am #7068

    Dennis @ PerfectForms
    Blocked

    I deleted the new topic forum post and added it to this string as it is a continuation…

    This may be beyond the scope of Perfect Forms, but is it possible to convert date difference results based on the 24 hours day to an eight hour work day? I am capturing the Beginning Date/Time and Ending Date/Time then trying calculate the days, hours, and minutes used. It looks like I also have to consider the start and end of each persons workday and exclude weekends and holidays. Any help would be appreciated.

    Thanks

    April 11, 2014 at 8:04 am #7070

    Dennis @ PerfectForms
    Blocked

    This capability is certainly not native in PerfectForms,. You could probably build the behavior. The first step is to fully and completely define the requirement. Once you have done that you may find that there is a web service available to do the calculation for you. Then you would simply have to create a web service connection as described in our help guide: /Documentation/manual/html/?d_webservicesconnections.htm. If you need it built in PerfectForms we could provide a quote once the requirements are fully defined.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.

Add a topic
Do NOT follow this link or you will be banned from the site!