formula help

[Guest]

Hello, I have a formula in a text box and it is =[DT REGULAR]/[EMPLOYEE TIME]
I get almost the correct answer I need but I have to add .83 to the total
which is 50 minutes. Can someone help me with this formula

 

[John W. Vinson]

Hello, I have a formula in a text box and it is =[DT REGULAR]/[EMPLOYEE TIME]
I get almost the correct answer I need but I have to add .83 to the total
which is 50 minutes. Can someone help me with this formula

What's the datatype of the field? Number, or Date/Time? If it's number just
add .83:

=[DT REGULAR]/[EMPLOYEE TIME] + .83

If it's Date/Time... reconsider. Date/Time values are best used for precise
points in time, not durations. If you really insist, try

=DateAdd("n", 50, [DT REGULAR]/[EMPLOYEE TIME] )


John W. Vinson [MVP]