Calculating time.

[Floyd Forbes]

How do I calculate the total time in a textbox on a report . I have textbox1
that shows 5.109722222222 and textbox2 "=CDbl(CDate([sumoftotal]))"
3:23. Textbox1 is more than 24:00. How can I calculate time over 24:00
in texbox2.

Floyd

 

[Marshall Barton]

How do I calculate the total time in a textbox on a report . I have textbox1
that shows 5.109722222222 and textbox2 "=CDbl(CDate([sumoftotal]))"
3:23. Textbox1 is more than 24:00. How can I calculate time over 24:00
in texbox2.

Multiply by 24??

Really, your problem statement is too vague to get a
specifiv answer. Generally you should be calculating an
elapsed time in the smallest unit that you are interested
in, probably minutes in this case. Then use an expression
like et\60 & ":" & Format(et Mod 60, "00") to display the
total as hours and minutes.