Microsoft 365 Apps and Services for Work and School Accounts
View All Tags
SharePoint has one column type for dates, Date and time, and one switch, Include Time, decides what it holds: a date, or a date and a time. This guide shows both, and how to choose.
A Number column accepts any number unless you tell it otherwise. Minimum allowed value and Maximum allowed value set the range, and SharePoint refuses to save anything outside it. It's the simplest guard a list can have.
A Number column holds counts and measurements: minutes, hours, quantities, IDs. Its settings decide how the numbers look, what a new item starts with, and which numbers are allowed. This guide adds one and walks through each setting.
A SharePoint site with US settings shows a night shift starting at 10:00 PM. Hospitals, rotas and timesheets usually write that as 22:00. The site's Time format setting switches every time on the site to the 24-hour clock.
If your SharePoint site shows 7 November as 11/7/2026, it's using the US date format. The format comes from the site's Locale, in Regional settings. Set it to your country and the same date shows as 07/11/2026.
A new SharePoint site doesn't pick up your time zone or your browser's. It takes the default from the SharePoint admin center, which is Pacific Time unless an admin has changed it. One setting, in the site's Regional settings, gives the site its own time zone.
Picking an approver in a SharePoint list, I typed "Olivia" and got Olivia Bennett, Head of Sales. Her job title had been changed to Emergency Department Manager in Microsoft Entra ID earlier the same day. Nothing was wrong with Entra: SharePoint keeps its own copy of each person's profile, and that copy hadn't caught up yet.
Many teams still record overtime in a shared Excel workbook: who worked, when, why, and who said yes. This series replaces it with a Power Apps app on SharePoint. Staff log overtime in a few taps, the hours are calculated and totalled for them, each department's approvers approve it in Teams or Outlook, and payroll gets a monthly Excel workbook and a Power BI report. Everything runs on Microsoft 365.
On the night the clocks go back, a 22:00 to 06:00 shift lasts 9 hours. Excel says 8, because its dates and times know nothing about clock changes. In spring it's the other way: the shift lasts 7 hours and Excel still says 8. This guide works out when the UK clocks change in a given year and corrects each shift's hours.
AND checks several conditions at once and returns TRUE only if every one of them is true. =AND(A10<$C$7,B10>$C$7) asks "did this shift start before C7 and finish after it?". And because Excel treats TRUE as 1 in arithmetic, the answer can be added straight into a total.
