Search results for query: *

Thank you to everyone who tried to help with my question.

no my actual string is this: Elapsed Time: Format([Screening Stop]-[Screening Start], 'hh:nn') and it comes back with the compile error Thanks for the FAQ links (PHV) I did go read them beings I am new to this. My boss told me about this site.

I am about to give up. Compile error. in query expression Format([stop date]-[start date],'Short Time') is what I am getting back. I know I picked short time in my table but I didn't pick that in my query I am actually building the expression in my query. I do greatly appreciate your help and...

Thank you I tried that and here is what I got: Syntax Error (comma) in query expression '([stop date]-[start date], 'hh:nn') if I take out the comma I still get an error.

I am trying to take a start date and time and a stop date and time subtract them (stop from start) can do this no problem BUT it comes out in decimal. I need it to come out in hours and minutes format in a table and a Query. I keep getting an operand error no matter what combination I use. Does...