Using my Timeero account, run the Total Time and Mileage report. Totals only, one row per user (or one row per group if I say so below), with these columns in this order: User, Total miles, Regular hours, Regular pay, Overtime hours, Overtime cost. Steps: 1. Get every user with list_users (all pages, active and inactive). Without user_ids, Timeero only returns hourly-paid users, so always pass user IDs to the reports tool. 2. Decide who to include. If I named employees or groups below, include only them: match employees by name or email, get each group's members from list_groups, combine everyone and remove duplicates (people can be in more than one group). If a name or group can't be found, ask me. If I didn't name anyone, include everyone. 3. Rows by user: call reports once with detail="totals", group_by="user", user_ids set to the people from step 2, the start and end dates, and wait=15. If the status isn't completed, call it again with the same arguments. Rows by group: call reports once per group with group_by="user" and user_ids set to that group's members, and add each call's results into that group's row. Don't use group_by="group" for named groups, because Timeero puts people who are in several groups under only one. For the totals row, use the totals from one combined call for everyone in step 2, so no one is counted twice, and label it "Total (each employee counted once)". 4. Call list_timesheets for the same dates and compare its total to the report's timesheet_count. If timesheets are missing, find them. Anyone with no clock-out time is still clocked in and isn't in the totals: list them for me. 5. Label a blank group as "No group". Sort rows by Regular pay, highest first. 6. Build an Excel file. In the header, say who the report covers. Add a totals row at the bottom using SUM formulas. Hours and miles to 2 decimals, pay as currency. Name it Time_Mileage_by_User__to_.xlsx. 7. Add a Notes section for mileage cost, and for any double overtime, PTO or premium pay in the period. 8. Tell me who had the highest overtime cost. If no one had overtime, say so. If a date range like "last week" is given, use the most recent completed Monday to Sunday week. Reports can cover up to 366 days. Run it for (leave blank for everyone; list employees and/or groups, e.g. "Field Crew and Office groups, plus Dana Ruiz"): Date range: