Calculated Controls (Need to calculate time difference and total times elapsed)

[Alphix]

Field 1A = 1:00:00 pm
Field 2A = 1:15:00 pm

(Need total time elapsed in Field 3A)

Field 1B = 2:00:00 pm
Field 2B = 2:15:00 pm

(Need total time elapsed in Field 3B)

Field 4C = Total of field 3A + 3B

(01) I do not know what formula to type in field 3A and 3B to calculate in decimals
(02) I do not know what formula to type in field 4C to add 3A and 3B to get the Total results.

Please help

Thank you in advance.

[ssanfu]

Do you want the results as decimal hours (3A = 0.25 hrs) or minutes (3A = 15.0 minutes)??
Use the DateDiff() function.

Just add 3A and 3B together as you demonstrated.

[Alphix]

I would like to have it in decimal hours.
Can this be done? if so how can I write this out?

[ssanfu]

Can this be done? if so how can I write this out?

Look in Help for the DateDiff() syntax.

[Alphix]

I tried the below formula.

=DateDiff("n",[Time1Start],[Time1Stop])\60 & "." & Format(DateDiff("n",[Time1Start],[Time1Stop]) Mod 60,"00")

The result is not a true decimal number because of the input of "." and "00"

I am confused on how to make this a true decimal number.

[June7]

Cut off the "." and the following expression.

Dividing by 60 will return decimal hours. Don't worry about displaying decimal placeholders in query. Format textbox on report.

However, can set the Format property for each field in query - I have never bothered with this.

[Alphix]

time calculator.zip



I have hit the wall in trying to figure out how to make my field box add up the total times.
Also the results in A & B are not real numbers. How do I make these boxes have real numbers?

Can someone help me fix???

Please see attachment.

Thank you in advance.

[June7]

The answer was provided in your other thread. Same topic so I combined them. See post 6.

However, expressions in textboxes are not properly calculating because you have the wrong symbol for division operator. Should be / not \.

[Alphix]

Thanks for the previous help. Yes your answer did work for the 2 top fields.

Now I am having trouble calculating the totals in the Total field box.

The box seems to keep recognizing both top field results as text and just treat it

as an addendum instead of adding the numbers together.

Please help.

time calculatorREV2.zip

Thanks in advance.

[June7]

You still haven't done what I suggested.

Result_A: =DateDiff("n",[Time1A],[Time2A])/60

Result_B: =DateDiff("n",[Time1B],[Time2B])/60

Now set the Format and DecimalPlaces properties of the textboxes.

[Alphix]

Thanks...Yes that did the trick.