Seperating Numeric Values Into Whole and Part Values

[ebarrera]

I need to convert a numeric value into two values (Whole & Part). For example, 2.400 is the numeric value for field ContactTime. I need two seperate numeric values for fields called Hours = 2.000 and Minutes = 0.400. ContactTime is a calculated field that uses the DateDif() between two times. The seperation between the two is needed to conver minutes into a 50 minute clock. Is there a function for this?

 

[pbaldy]

Look at the Int() function.

 

[ebarrera]

Oh yeah, that will get me the hours and then subtracting that from the ContactTime it should get me the difference. I will try that out. Thanks.

 

[ebarrera]

Worked like a charm, Thanks.

 

[pbaldy]

Happy to help. I think I played golf in Chula Vista years ago. Nice area.