Calculating Time in Queries

[laboi_22]

I have the following feilds in a query: Timein Timeout
I need a subtotal feild that totals the two across midnight
I also need a Lunch feild
Then I need a total feild with the subtotal and total subtracted

I tried using this expression please help anyone if you can

Format([Timein] -1 -[Timeout], "Short Time") this created my subtotal feild

then I had a made lunch feild with 30 mins of time into it

then i tried Format([subtotal] -1 -[lunch], "Short Time") and called this one my total box.

The first one worked the second reported an error. Please any suggestions??

 

[laboi_22]

anyone???????

 

[EMP]

Try this:
Format(TimeValue([Subtotal])-[Lunch], "Short Time")

^

 

[laboi_22]

thank you so much that was the last thing I needed to complete my staffing program.