Working-Time Engine Setup Guide
Industrial-grade calculation engine for Smartsheet. Handles cross-midnight shifts, break logic, and rounding with high-precision API-driven math.
Before You Start
- Ensure you have Start and End time columns in your sheet (Text/Number or Time format).
- Create a Duration column (Text/Number) where the engine will write the results.
- Recommended: Add an Error Log column for status feedback during setup.
- Define your Time Policy (e.g., standard break durations, rounding rules).
Step-by-Step Configuration
- Authentication
Select "Working-Time Engine" from the SmartSync dashboard and authorize your Smartsheet account.
- Column Mapping
Map your Start and End time columns. Choose your Output column for the net duration.
- Overnight & Logic Pulse
Enable "Overnight Support" if your workforce operates across midnight (e.g., 10 PM to 6 AM). The engine uses 24-hour wraparound logic to ensure accuracy.
- Configuring Breaks
Choose between fixed deductions (e.g., 30 mins) or dynamic deductions mapped to a specific sheet column.
- Setting Precision
Select your rounding increment (1m, 5m, 15m) and direction (Nearest, Up, or Down).
Configuration Options Explained
| Option | Behavior | Best Practice |
|---|---|---|
| Overnight Support | Correctly calculates time when End Time is "earlier" than Start Time. | Enable for all 24/7 operations. |
| Break Source | Subtracts duration (Fixed value or Sheet Column). | Use "Sheet Column" for variable lunch periods. |
| Rounding Rule | Adjusts result to nearest 6, 15, or 30 minute block. | Use 15m rounding for standard US payroll. |
| Output Format | Decimal Hours (8.5) or HH:MM (08:30). | Use Decimal for easier cost calculations. |
Expert SME Insight: Managing "Phantom Time"
In high-volume payroll environments, "Phantom Time" — inconsistencies caused by manual formula miscalculations or timezone shifts — costs enterprise companies thousands monthly. By offloading math to an external engine, you create an Immutable Audit Trail.
Professional Strategy: Always keep your raw input columns as "Source of Truth" and use the Engine to write to a "Gross Hours" column. Never perform secondary math on the output; let the Engine handle rounding and deductions in one atomic operation to maintain data integrity.
Troubleshooting & Resolution
- Negative Duration?
This typically means a shift crossed midnight but "Overnight Support" was disabled. Toggle this on in your configuration dashboard.
- Result says "Invalid"?
Verify that your time columns do not contain text like "N/A" or "TBD". The engine requires a valid timestamp string or Smartsheet time object.
- Delay in Writeback?
Smartsheet webhooks can take 1-3 seconds to fire. For bulk updates (100+ rows), use our "Backfill" tool instead of saving manually.