Calculating time.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

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
 
Floyd said:
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.
Click to expand...


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.
 
Back
Top