Calculating Time

[Guest]

I have two fields on a form called Start time and Duration. The duration
field is inputted manually in hours and minutes.

I am wanting to calculate the total time on the Duration field

How do I achieve this?

David

 

[Stefan Hoffmann]

hi David,

I have two fields on a form called Start time and Duration. The duration
field is inputted manually in hours and minutes.

It would be better to store the end time.

I am wanting to calculate the total time on the Duration field

Take a look at DateAdd/DateDiff in the OH.


mfG
--> stefan <--

 

[Guest]

David,

How are you storing hours and minutes, as a text string "hh:mm", or in some
other format?

I agree with Stefan that it is easier to store the end Time.

BTW, I would use a full date/time format to store a date/time combination
rather than just storing the time.