Skip to main content

November 2026

Every post published in November 2026, newest first. Pick a day to jump straight to it.

Posts
802
Topics
75
Reading time
91 h
Active days
15

Posts 331–360 of 802 · November 7, 2026

Page 12 of 27

Saturday, November 7, 2026

30 of 94 posts

  1. How to Show Total Hours Over 24 in Excel

    Show a total of times as 60:15 instead of 12:15 in Excel with the custom format [h]:mm. Why hh:mm wraps at 24 hours, and how to apply [h]:mm in Excel for the web.

  2. How to Add Up a Row or Column with SUM in Excel

    Add up a row, a column or a whole table column in Excel with SUM: =SUM(B2:C2) across, =SUM(B2:B4) down, =SUM(OvertimeLog[Time worked]) for a table, with real totals from a timesheet.

  3. How to Sum Values Between Two Dates in Excel with SUMIFS

    Add up values whose date falls in a range with SUMIFS and two date conditions: ">="&start and "<"&end. Why the operator goes in quotes, why & joins it to the cell, and why the end is exclusive.

  4. How to Total Hours by Person and Month in Excel with SUMIFS

    Build a grid of overtime totals, one row per person and one column per month, from a log of shifts with a single SUMIFS formula copied across the grid. Every part of the formula explained.

  5. How to Use Absolute and Mixed Cell References in Excel

    Use $ in Excel references so copied formulas keep pointing where they should: $C$7 never moves, $A2 keeps its column, B$1 keeps its row. Real examples from a timesheet grid.

  6. How to Get the First Day of the Next Month in Excel with EDATE

    Turn 01/10/2026 into 01/11/2026 with =EDATE(B1,1): EDATE moves a date by whole months and keeps the day, so starting from the 1st gives the next month's first day.

  7. How to Create a Drop-Down List in Excel for the Web

    Limit a column to set choices with a drop-down list in Excel for the web: Data → Data Validation → Allow List, type the choices separated by commas, keep In-cell drop-down, Apply.

  8. How to Rename a Worksheet in Excel for the Web

    Rename a sheet tab in Excel for the web: right-click the tab, select Rename, type the new name and press Enter. Plus the naming rules a sheet name has to follow.

  9. How to Add a Worksheet in Excel for the Web

    Add a new sheet to a workbook in Excel for the web with the New sheet + button next to the sheet tabs, or Shift+F11, and give it a name straight away.

  10. How to Show a Date as Month and Year in Excel

    Show 01/10/2026 as Oct 2026 in Excel with the custom format mmm yyyy, so month headings read naturally while the cells keep real dates that formulas like SUMIFS can use.

  11. How to See the Serial Number Behind a Date in Excel

    Excel stores every date as a number of days: 1 October 2026 is 46296. See it by switching the cell to General, then undo. Why it matters for date maths, times and totals.

  12. How to Use a Custom Number Format in Excel for the Web

    Apply a custom number format such as mmm yyyy, [h]:mm or dd/mm/yyyy hh:mm in Excel for the web: More Number Formats → Custom, type the code and confirm it, or pick one from the list.

  13. How to Change a Cell's Number Format in Excel for the Web

    Change how Excel for the web shows a value without changing the value: the Number Format list on the Home tab, what each option does, and three real cases from a timesheet.

  14. How to Convert Time to Decimal Hours in Excel

    Turn a time like 3:30 into 3.5 hours in Excel: multiply by 24, then format the result as a number, because Excel gives it a time format first. Why 24 and what to check.

  15. How to Subtract an Unpaid Break from Hours Worked in Excel

    Take an unpaid break off a shift's hours in Excel: the time between start and finish, overnight shifts included, minus the break in minutes divided by 1440. One formula, explained piece by piece.

  16. How to Convert Minutes to a Time in Excel by Dividing by 1440

    Turn a number of minutes, like a 30-minute break, into an Excel time you can add or subtract: divide by 1440, the minutes in a day. Why 1440, and the formula in a real timesheet.

  17. How to Calculate Hours for an Overnight Shift in Excel with MOD

    Get the right hours for a night shift like 22:00 to 06:00 in Excel with =MOD(Finish-Start,1), which counts forward past midnight instead of going negative. How MOD does it, with real results.

  18. How to Calculate Hours Between Two Times in Excel

    Work out how long a shift lasted in Excel by subtracting the start time from the finish time, why the result is a time like 04:00, and what to do when the shift ends after midnight.

  19. How to Add a Calculated Column to an Excel Table

    Add a column to an Excel table by typing a heading next to it, then type one formula and Excel fills it down every row. Change the formula once and the whole column follows.

  20. How to Use Structured References in an Excel Table

    Write table formulas with column names instead of cell addresses: [@Finish] for this row's Finish, [@[Break (mins)]] for names with spaces, OvertimeLog[Hours] for a whole column.

  21. How to Copy a Formula to Other Cells in Excel

    Copy a formula down to more rows with Ctrl+C and Ctrl+V, and see how Excel adjusts its cell references for each row while references with $ stay fixed.

  22. How to Use the Formula Bar in Excel for the Web

    Read and type formulas in Excel for the web's formula bar: see what a cell really holds, type long formulas with room to spare, and match each coloured reference to its cell.

  23. How to Enter a Formula in Excel

    Type your first Excel formula: start with =, refer to cells by their addresses, watch Excel colour each reference, and press Enter to see the result while the formula stays in the formula bar.

  24. How to Rename a Table in Excel

    Give an Excel table a meaningful name in the Table Name box on the Table Design tab, so formulas read OvertimeLog[Hours] instead of Table1[Hours] and other tools can find it by name.

  25. How to Format Data as a Table in Excel

    Turn a range of rows into an Excel table with Home → Format As Table: pick a style, confirm the range and My table has headers, and get filters, banded rows and formulas that fill down.

  26. How to AutoFit Column Width in Excel for the Web

    Make Excel for the web size columns to their contents: select the columns, then Home → Format → Auto Fit Column Width. Fixes ######## dates and cut-off text in one go.

  27. How to Paste Tab-Separated Data into Excel

    Paste rows of tab-separated text into Excel for the web so every value lands in its own column: copy the text, select the first cell, press Ctrl+V. Then widen the columns to read it.

  28. How to Enter a Date and Time in One Cell in Excel

    Type a date and a time into a single Excel cell, like 24/10/2026 22:00, so Excel stores both as one value you can subtract. The format it gets, and what the formula bar shows.

  29. How to Go to a Cell or Range with the Name Box in Excel

    Select any cell, range or whole column in Excel by typing its address in the Name Box, the box at the left of the formula bar, and pressing Enter. No scrolling or dragging.

  30. How to Enter Data with Tab and Enter in Excel for the Web

    Type a row of data in Excel for the web without the mouse: Tab moves right, Enter moves down from the cell you're in, and Home jumps back to column A for the next row.