Difference Between Two Dates WITH A TWIST

[pianoprodigy]

I need to find the HOURLY difference between two dates. One of the dates is automatically generated in the full format including time. The second date uses two fields and is manually entered: Sign Up Date, Sign Up Time. I want to be able to find the HOURLY difference between these two dates. Is there a way to combine the [Sign Up Date] and [Sign Up Time] fields so that it will be similar to the automatically generated date?

Thanks in advance for your response.

 

[Jon K]

If the two fields are date/time fields, you can combine them with the + sign:-
[Sign Up Date] + [Sign Up Time]

 

[pianoprodigy]

Duh, that was easy! Thanks!