beregning af timer og minutter

Use the Datediff function for this

diff = DateDiff("n", ATD, ETD)

OK, you dont want it in minutes I can see

busy with something else right now will get back to this later if you dont get an answer

you can try this

DateDiff("h", ATD, ETD) & ":" & DateDiff("n", ATD, ETD) Mod 60

Hi,
It working with (Hour([ATD]-[ETD]) & ":" & Minute([ATD]-[ETD]))It didn´t worked with DateDiff, BUT I have another problem, how do I get sum of those minutes and hours. total hours spend in a month??

Dont see why it doesnt work with Datediff!

To get the total hours+minutes you will also need a date field to make sure you only select records between these dates.

The easiest way is to do it is in a query.

Når jeg bruger (Hour([ATD]-[ETD]) & ":" & Minute([ATD]-[ETD])) hvordan kan jeg så få summen af de timer talt sammen, antal timer brugt i løbet af hele mdr. ??

iwa30>I can only make some suggestion as I do not know enough about your database.
As I said previously you MUST have a date field for this and if you do have a date field then you may as well have your date and time in the same field. Then you can make a query wher you make a calculated field to calculate the difference in minutes for each day and then include a criteria to select only those records for the dates you are interested in. Then once you have these records you can then sum the minutes in an aggregate query.