Learn one useful thing today.
Convert seconds to Excel time (Seconds / 86400) & HH:MM:SS over 24 hours
Transform raw call-center ACD seconds and video durations into Excel fractional-day serials and rollover-proof HH:MM:SS strings.
Read the guide →TextConvert snake_case, kebab-case, camelCase, and Human Title labels
Transform database column names (customer_first_name) into report headers ("Customer First Name"), camelCase ("customerFirstName"), and ENV_VARS.
Read the guide →Date & TimeConvert spreadsheet dates to Unix timestamps (and Unix epoch seconds back to dates)
Translate UTC date-time serials to Unix seconds using DATE(1970, 1, 1) and 86400 seconds/day—including millisecond API feeds.
Read the guide →Lookup & ReferenceConvert State and Region Names to 2-Letter Postal Codes (Bidirectional XLOOKUP)
Standardize mixed CRM address columns that contain both full state names ("California", "new york ") and existing 2-letter postal codes ("TX") into clean ISO/USPS codes without #N/A errors.
Read the guide →FinancialConvert time worked into money: billable hours x hourly rate formula
Multiply spreadsheet HH:MM durations by 24 * HourlyRate to avoid the 24x underbilling bug, and enforce minimum callout fees.
Read the guide →Date & TimeConvert timestamps across time zones: UTC offsets and midnight rollover
Add OffsetHours / 24 to full date-time values to shift calendar dates automatically across midnight, or wrap time-only values with MOD.
Read the guide →TextConvert Y/N schedule columns into days-of-week text ("Mon, Wed, Fri")
Turn seven Y/N delivery or availability flags into a weekday label list and a matching count.
Read the guide →Date & Time FormulasConvert Year & Day-of-Year Number (1–366) to Calendar Date
Convert ordinal day-of-year numbers (e.g., Year = 2026, Day = 135 -> 2026-05-15) into ISO calendar dates via DATE(Year, 1, Day_Number) while catching invalid Day 366 in non-leap years.
Read the guide →Hybrid Securities, Corporate Finance & Equity-Linked DebtConvertible Bond Parity, Premium & Breakeven Formula
Calculate Corporate Convertible Bond Conversion Ratio (Par / Conv_Price), Equity Conversion Parity Value, Dollar & Percentage Conversion Premium, and Coupon-vs-Dividend Income Payback Years.
Read the guide →Venture Capital & Seed FinancingConvertible Note Cap vs Discount Conversion Formula
Calculate Accrued Simple-Interest Note Balance, Effective Conversion Price MIN(P_round * (1 - d), V_cap / S_pre), Converted Preferred Shares, and Day-1 Paper Multiple on Principal.
Read the guide →Engineering & ScienceConwell-Weisskopf Ionized-Impurity Mobility & Matthiessen Total μ
Calculate Coulombic ionized-impurity carrier mobility μ_CW (cm^2/(V·s)) via Esther Conwell and Victor Weisskopf’s screened T^(3/2)/N_I Rutherford formula and combine with phonon mobility μ_L by Matthiessen’s Rule.
Read the guide →Engineering & ScienceCooling Fin Efficiency (eta_fin) & Fin Effectiveness (epsilon_fin) Heat-Sink Formula
Calculate the extended-surface fin parameter m*L = L * SQRT((h * P) / (k * Ac)), adiabatic-tip fin efficiency eta_fin = tanh(m*L) / (m*L) (%) via exact EXP identity, and fin effectiveness epsilon_fin.
Read the guide →HVAC Central Plants, Industrial Water Treatment & Mass BalanceCooling Tower Cycles of Concentration & Blowdown Formula
Calculate Cooling Tower Evaporation Loss (GPM), Chloride Cycles of Concentration (COC), Controlled Basin Blowdown Rate (GPM), and Total Makeup Water Demand (GPM).
Read the guide →Central Chiller Plant Condenser Water, CTI Evaporative Cooling Towers & Wet-Bulb ApproachCooling Tower Range, Wet-Bulb Approach & Effectiveness Formula
Calculate Condenser-Water Cooling Range T_hot - T_cold (°C), Wet-Bulb Approach T_cold - T_wb (°C), Cooling Tower Thermal Effectiveness (%), and Total Heat Rejection Rate (kW).
Read the guide →EngineeringCooper-Jacob Transient Well Drawdown Formula (Theis Approximation)
Estimate constant-rate confined-aquifer drawdown using the Cooper–Jacob late-time approximation. Calculate u, apply a conservative small-u screen, and inspect drawdown per tenfold increase in time.
Read the guide →Flight Mechanics, Aerodynamics & Aviation SafetyCoordinated Level Turn: An Idealised Load-Factor Example
Explore load factor, a relative stall-speed multiplier and turn radius for a simplified steady coordinated level turn.
Read the guide →RF & Microwave PCB Design, Coplanar Waveguide (CPW) Elliptic Impedance & DelayCoplanar Waveguide (CPW) RF PCB Impedance Z0 Formula
Calculate CPW Elliptic Modulus k0 = w/(w + 2g), Half-Space Effective Permittivity (1 + eps_r)/2, Hilberg Characteristic Impedance Z0 (Ohms), and Phase Velocity (mm/ns).
Read the guide →Extractive Metallurgy & Precious-Metals Recovery, Electrolytic Copper Refining TankhouseCopper Electrorefining Anode Cycle, Scrap & Slime Formula
Calculate Dissolvable Anode Copper Mass (kg), Faraday Daily Cathode Plating Rate (kg/d), Anode Campaign Life Before Scrap Pull (days), and Au/Ag/Se Anode Slime Yield (kg/anode).
Read the guide →Hydrometallurgy & Electrochemical Refining, Copper SX-EW Tankhouse Faraday BalanceCopper Electrowinning Tankhouse Harvest & kWh/t Formula
Calculate Daily LME Grade-A Copper plated per Electrolytic Cell (kg/day), Total Tankhouse Cathode Harvest (t/day), Rectifier DC Bus Load (MW), and Specific DC Energy (kWh/t Cu).
Read the guide →Lookup & ReferenceCopy Value from Every Nth Row or Column into a Clean Table (INDEX)
Reshape regular vertical blocks using INDEX and a stride, or extract every Nth column from a horizontal source. Includes explicit output anchors and bounds checks.
Read the guide →Statistical & Clinical AnalysisCornfield 2x2 Odds Ratio Quadratic Expected Cell A(psi) & Score Test Formula
Evaluate Jerome Cornfield’s (1956) noncentral hypergeometric quadratic expected cell count A(psi), conditioning variance V(A), and continuity-corrected chi-square score X^2(psi) for any hypothesized 2x2 Odds Ratio psi.
Read the guide →FinancialCornish-Fisher Modified VaR (mVaR) formula: Skewness & Excess Kurtosis Tail Risk
Explore a truncated Cornish-Fisher quantile approximation and compare its illustrative loss threshold with a Gaussian calculation.
Read the guide →Debt Capital Markets, Corporate Bond Indentures & Liability ManagementCorporate Bond Make-Whole Call Price & Par Floor Formula
Calculate Investment-Grade Corporate Bond Semiannual Make-Whole Discount Rate (Benchmark Treasury + Spread), Present Value of Remaining Coupons and Principal, Contractual MAX(Par, PV) Redemption Price ($), and Make-Whole Premium %.
Read the guide →Corporate Divestitures, Carve-Out Accounting & Spin-Off ValuationCorporate Carve-Out Standalone Cost & Stranded Overhead Formula
Calculate Divisional Carve-Out GAAP EBITDA (Direct EBITDA - Allocated Parent Corporate Cost), Standalone G&A Cost Delta (Dis-Synergies vs Cost Savings), True Standalone Run-Rate EBITDA, and RemainCo Unabsorbed Stranded Overhead.
Read the guide →Corporate Finance, Net-Lease Real Estate & Sale-Leaseback StructuringCorporate Sale-Leaseback Debt-Paydown Arbitrage Formula
Calculate Industrial / Retail Sale-Leaseback Gross Valuation Proceeds (NNN Rent / Cap Rate), Net After-Tax Debt Paydown After Capital-Gain Tax on Low-Basis Real Estate, Annual Interest Saved, and Pre-Tax Annual Cash-Flow Accretion / Dilution ($M).
Read the guide →Corporate Finance, M&A Divestitures & IRC Section 355 Split-OffsCorporate Split-Off Exchange Offer Proration & EPS Formula
Calculate IRC Section 355 Split-Off Parent Shares Retired (M), Oversubscribed Tender Proration Factor (%), Post-Split RemainCo EPS ($/sh), and EPS Lift vs Pro-Rata Spin-Off (%).
Read the guide →Quantitative Finance & DerivativesCorrado-Miller Closed-Form Implied Volatility for Non-ATM Options
Extract implied volatility away from the money without Solver using the Corrado-Miller (1996) quadratic moneyness correction and spot why ATM Brenner-Subrahmanyam overstates ITM vol.
Read the guide →StatisticalCorrected QT Interval (QTc) ECG formulas: Bazett (SQRT) vs Fridericia (Cube Root)
Compare Bazett and Fridericia heart-rate corrections using QT in milliseconds and heart rate in beats per minute.
Read the guide →Health & FitnessCorrected Sodium in Hyperglycemia: Katz and Hillier Estimates
Compare two commonly reported sodium correction estimates with clear units and limits; neither replaces the measured sodium value or clinical assessment.
Read the guide →StatisticalCORREL function: measure positive, negative, and zero linear correlation
Calculate the Pearson correlation coefficient (-1 to +1) between two paired metrics with CORREL, and understand why constant series return #DIV/0!.
Read the guide →Quantitative FinanceCorwin-Schultz High-Low Bid-Ask Spread Estimator Formula (2-Day vs 1-Day)
Estimate effective percentage bid-ask spreads from daily High and Low bars alone using the Corwin & Schultz (2012) two-day range decomposition.
Read the guide →MathCOS function: calculate horizontal run from sloped distance and angle
Project sloped survey or rafter lengths onto the horizontal ground plane with COS(RADIANS(angle)), and round floating-point noise at 90 degrees.
Read the guide →StatisticalCosine Similarity and Euclidean Distance between two vectors in cells
Compare embeddings, customer preference profiles, or document term vectors using SUMPRODUCT dot products and L2 vector norms.
Read the guide →FinancialCost-of-carry price model: compare a maturity price with spot
Explore Spot × EXP((financing + storage - yield) × years), with explicit continuous-rate assumptions and a comparison against spot.
Read the guide →FinancialCost-of-living adjustment (COLA): percentage raises, dollar caps, and reverse base
Calculate adjusted salaries with Base * (1 + Pct), enforce maximum raise caps with MIN, and recover pre-raise pay accurately.
Read the guide →FinancialCost-to-cost project progress: a simplified revenue and billings worksheet
Practice cost-based progress and cumulative catch-up arithmetic. Determine applicable ASC 606 or IFRS 15 accounting separately before using a project model.
Read the guide →Math & EngineeringCotangent (COT), Cosecant (CSC) & Secant (SEC) Roof Pitch & Optical Formulas
Calculate cotangent, cosecant, and secant from degree or radian angles using exact COS/SIN and 1/SIN identities while guarding 0 and 180 degree singularities.
Read the guide →Engineering & ScienceCottrell Equation: Chronoamperometry Diffusion Current i(t) & Nernst Layer Thickness
Calculate t^(-1/2) planar diffusion current i(t) = (n * F * A * C0 * SQRT(D)) / SQRT(PI() * t) in microamps and Nernst diffusion-layer thickness delta = SQRT(PI() * D * t) in electrochemical sensors.
Read the guide →EngineeringCouette Shear Stress, Viscous Heating & Rotational Viscometer Torque
Compute planar Couette shear and viscous dissipation, then compare narrow-gap torque with the ideal concentric-cylinder solution using the same inputs.
Read the guide →Retaining Wall Design, Lateral Earth Pressure & Limit EquilibriumCoulomb Active Earth Pressure Coefficient (Ka) & Thrust Formula
Calculate Coulomb Active Coefficient K_a (with Wall Friction delta, Battered Stem beta & Backfill Slope alpha), Inclined Active Thrust P_a (kN/m), Horizontal Sliding Thrust P_ah (kN/m), and Stabilizing Vertical Shear P_av (kN/m).
Read the guide →EngineeringCoulomb Active Retaining-Wall Earth Pressure (Ka) & Horizontal Thrust
Calculate Charles-Augustin de Coulomb's Active Earth Pressure Coefficient K_a (accounting for soil friction phi, wall-soil friction delta, and sloping backfill beta) and horizontal overturning thrust P_ah.
Read the guide →EngineeringCoulomb's Law Electrostatic Force & Electric Field Strength formulas
Calculate point-charge electrostatic force F = ke * |q1 * q2| / r^2, attractive/repulsive polarity, and electric field E = ke * |q1| / r^2.
Read the guide →Data Cleaning & TextCount & Audit Cells Containing Exactly N Characters (REPT "?" & LEN)
Count text codes matching an exact character length N using COUNTIF(range, REPT("?", N)) and flag truncated or padded SKU/IBAN entries row by row with LEN(TRIM(cell)).
Read the guide →Text & Regular PatternsCount & List Which Keywords Appear Inside a Single Text Cell
Score support tickets, contract clauses, or incident notes by counting how many distinct keywords from a watchlist appear inside one cell and listing every matched keyword.
Read the guide →Conditional AggregationCount & Sum Cells Ending With or Starting With Specific Text (COUNTIF / SUMIF)
Match SKU suffixes ("*" & suffix) and regional prefixes (prefix & "*") dynamically with COUNTIF and SUMIF while preventing blank-affix wildcard traps.
Read the guide →MathCount & Sum Odd vs Even Numbers in a Range (MOD, ISODD & SUMIF)
Test integer parity with MOD(n, 2) or ISODD/ISEVEN and count or sum odd-numbered vs even-numbered street addresses, lot IDs, and quantities cleanly across any spreadsheet engine.
Read the guide →Math & StatisticalCount 16+ Digit Card, IBAN & Tracking IDs Safely (Avoid COUNTIF 15-Digit Bug)
Count 16-to-22-digit card tokens, GS1 SSCC barcodes, and bank IDs accurately with SUMPRODUCT(--(A2:A6 = D2)), avoiding Excel COUNTIF's silent 15-significant-digit coercion bug.
Read the guide →Conditional AggregationCount Active Rows Not Equal to Multiple Terminal Statuses
Count non-blank records whose status does not match any item in an excluded list using SUMPRODUCT boolean inequalities or multi-criteria COUNTIFS.
Read the guide →MathCount and sum GL codes by the sixth character with positional wildcards
Use a sixth-character mask with literal target escaping, and sum matching numeric amounts.
Read the guide →Date & TimeCount Birthdays & Records by Year Cohort (Avoiding the Blank-Cell 1900 Trap)
Count birthdates or hire dates belonging to a specific calendar year or multi-year cohort using COUNTIFS date bounds and blank-guarded SUMPRODUCT + YEAR.
Read the guide →