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