How do I Sum Time Values

[spleewars]

The scenario is based on 2 data fields: "IN" and "OUT": both are time fields and the main function is to serve as a punch clock. In order to work out calculations and get the total time, both were passed into a query and set out the formula:

datediff ("n",[in],[out])

So to convert the raw time of the latter formula, i set a new one to divide the amount of 'datediff' into hours and minutes:

[totalhours]\60 & Format([totalhours] Mod 60, "\:00")

Everything's fine to here... however, when i loaded the query into a continuous form and set the SUM function into an unbound text box (so i could sum up all the totalhours) ERROR pops up. The control scorce of the textbox is:

=SUM([totalhours])\60 & Format(SUM([totalhours]) Mod 60, "\:00")

Obviously the textbox is set in the footer but still resolving the error.

What is the reason of the error?
Clara

[Rabbit]

The problem is that 3:45 is not a number. You can't add them up. What you need to do is sum up the minutes and do the conversion back into hours and minutes.

[spleewars]

Big thanks rabbit :) all i wanted was to be enlightened in this case! :)

[Rabbit]

Not a problem, good luck.