Hi Bill,
Try
DateDiff("s",#10:00AM#,#6:00PM#) function, where
"s" gives the result in seconds.
HTH, Igor
>I am having trouble with this one I have created a schedule with the fields "Time In” and "Time Out" both of these are on a 24hr clock. I cannot figure out how to get these to calculate the total time worked. Can anyone help?
>
>Thanks
>
>Bill
Igor Gelin
Database Developer