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
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.
4 min readHow 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 min readHow 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 min readHow 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 min readHow 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.
5 min readHow 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.
4 min readHow 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.
4 min readHow 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.
3 min readHow 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.
3 min readHow 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.
4 min readHow 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.
4 min readHow 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.
5 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
4 min readHow 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.
3 min readHow 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.
4 min readHow 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.
4 min readHow 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.
6 min readHow 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.
4 min readHow 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.
3 min readHow 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.
5 min read