Quick Question

[chivo123]

Hey all,


So I have converted the hours:min:seconds to all minutes by using this formula:
Total StafTotal Staff Time: IIf([calls handled]=0,0,(Hour([Total Inbound Talk Time])*60+Minute([Total Inbound Talk Time])+Second([Total Inbound Talk Time])+Hour([Total Outdial Talk Time])*60+Minute([Total outdial Talk Time])+Second([Total outdial Talk Time])+Hour([Total Outdial Wrap up Time])*60+Minute([Total Outdial Wrap up Time])+Second([Total Outdial Wrap up Time])+Hour([Total Inbound Hold Time])*60+Minute([Total Inbound Hold Time])+Second([Total Inbound Hold Time])+Hour([Total Inbound wrap up time])*60+Minute([Total Inbound wrap up time])+Second([Total Inbound wrap up time]))/[Calls Handled])

Is there an easier formula, so I can be able to save this to table?? I can't be able to add this formula to my table because it's very complex.

[RuralGuy]

Are the 4 fields all DateTime fields? You seem to be converting to minutes but then you add the seconds as if they were minutes. How about a UserDefinedFunction. It would be a lot easier to read and maintain.

[chivo123]

Hello,
Thanks for responding back. All of them are except for calls handled. It's a number. Other three of them are in hours:minutes:seconds.

[chivo123]

Also, how do i do UserDefinedFunction?

[RuralGuy]

Also, how do i do UserDefinedFunction?

This link should get you started: http://www.baldyweb.com/Function.htm
BTW...you still have the issue of adding in the seconds as if they were minutes.

[chivo123]

This link doesn't even relate to my question.. I just want to convert the formula above to seconds. I have changed them to minutes, but I would like to see if there another easier way to change it to minutes or seconds. Please don't post something irrelevant to what i'm asking.

[RuralGuy]

The link I posted was how to create a Function which was the last question you asked.