Check help on the function DateDiff, it can give the difference between two
date/time.
--
Good Luck
BS"D
"Adam@nospam.com" wrote:
> Hi All,
>
> I am trying to find a formula that I can use in Access to give the time
> difference in Hours.
>
> I have the following fields:
>
> [StartDate] , [StartTime] , [EndDate] , [EndTime]
>
> I want to find a formula that will provide a difference in time using
> the above fields. But I also need to look between the hours of 09:00am
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10362-date-and-time-difference.html
> to 5:30pm.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10362
>
> Does anything exist that can cover this?
>
> I can do this using Crystal reports however I am really struggling with
> Access.
>
>
> Many Thanks
>
> Adam
>
>