Recent content by mhinkle

Thanks Mike! I'll give it a try...

Thanks Jon Thanks Jon K. The example you provided is a great help. However, the "boss" is totally OCD, so he NEEDS the reports and query output for hours to display in hh:mm format. The roadblock here is that negative time is a problem, so if I work less than the 50 hours, my display is horked...

slightly confused Thanks Mike, but how would i use all these in one formula in my access query? I've never tried to string together several formulae on one field using the zoom box... It seems like it should be easier to work with time in access and excel ! I was trying to use excel first but...

Hello, I am trying to create a query that subtracts "TimeOUT" from "TimeIN" fields to calculate the total time worked. The "TotalTime" is a new field that is not in the table, only in the query. I am attempting to use the DateDiff function to calculate this, but I need to return both hours...