Recent content by tarus987

right now when I run the report, it only displays users that have entered a new timesheet for todays date. But I would like it to also show the rest of the employees names even though there is not a new record for todays date. That way when I run the report at the end of the day and export to...

I was able to accomplish this with the following code... HoursWorked: DateDiff("n",[Total Lunch],[Hours])\60 Mod 60 & ":" & Format(DateDiff("n",[Total Lunch],[Hours]) Mod 60,"00")

I have a couple of issues I'm running into in creating a timesheet. But mainly, I want to know is there a way to create a report that will show employees that inputted time, as well as indicate employees that have not in the same report? I have a table of Employees, & timesheets And I have a...

But now I'm trying to change the format from decimal to hour format.

Yes, I corrected the expression by adding parenthesis to the equation. Hours: (DateDiff("n",[ShiftStart],[EndShift])+([Total Lunch]))/60

I was able to correct this issue by adding additional parenthisis. However, I was looking to get the answer in hour format instead of decimal format. Such as 7hours 46min would reflects as 7.46 hours instead of 7.77 in decimal format. Hours: (DateDiff("n",[ShiftStart],[EndShift])+([Total...

I made a mistake in part of the query. Therefore the lunch column shows negative values such as -30, -60, -45. But even with this being the case, if I remove the /60 portion, it reflects 480 as being the total amount of minutes. But once I add the /60 back to the expression, it reflects 509.5

Hello, I was hoping someone could assist in correcting this expression. I am attempting to calculate the total number of hours minus the lunch break, and convert it to hour format. Total Hours: DateDiff("n",[ShiftStart],[EndShift])+([Total Lunch])/60