DateAdd Assistance

[BSULLY65]

I am writing a report that sums the amount of time a person spend on a function over a period of time. I am using the folling to calculate the sum for month

=Format(DateAdd("n",[txtEmpTotMinutes],#12:00:00 AM#),"hh") & ":" & Format(DateAdd("n",[txtEmpTotMinutes],#12:00:00 AM#),"nn")

txtEmpTotMinutes = the total minutes worked for month (The db stores all time in minutes)

As example one emp. has a total of 10,560 minutes spent but the above function returns 08:00.

What part of dateadd am I missing ?

 

[huh?]

Don't use the DateAdd function.
This returns a date, not the amount of time that has elapsed. Thus when you use this function on 10560 minutes, it returns a date, 7 days and 8 hours later. Since you are adding only the hour component to the time of 12 AM, of course you get 8 AM.

Try this instead:

= iif(Fix(txtEmpTotMinutes/60) Is Null, 0, Fix(txtEmpTotMinutes/60) & ":" & (txtEmpTotMinutes Mod 60)

By the way, if you are storing date/time values, you can caculate the difference between these date/times, i.e. elapsed time, by using DateDiff function.

Hope this helps

 

[BSULLY65]

This worked nicely, Thank You ! as for times everything is stored in minutes and gets calulated to hh:mm during queries and/or reports.

 

[huh?]

Glad I could help.