Calculate total hours within a time range

You have a Time value field on your form that will accept a range of time values i.e. 10:00 AM - 2:00 PM and you would like to set a field on your form with the total elapsed hours (4). The code here will calculate the total hours taking AM and PM into consideration.


Field name PartialDayTime is a Date/Time field that is set to accept only time values, allow multiple entries is checked and you are using the slider to enter values.

Field name Hours is a computed text field with the following in Default Value event

tmStart := @TextToTime(@Trim(@Left(@Text(PartialDayTime);"-")));
tmEnd := @TextToTime(@Trim(@Right(@Text(PartialDayTime);"-")));
@Text((tmEnd-tmStart)/60/60)

This was first published in April 2001

Dig deeper on Domino Resources - Part 2

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close