Microsoft 365 Apps and Services for Work and School Accounts
View All Tags
A blocked account keeps everything, so letting someone back in is one checkbox in the Microsoft 365 admin center. This guide unblocks Leo Martin, whose sign-in had been blocked, and shows the message that says when he can sign in again.
Changing someone's manager in the Microsoft Entra admin center isn't quite the same as setting one for the first time. The current manager stays selected when you pick the new one, so you have to remove them in the same panel. This guide moves Aisha Khan from Daniel Brooks to Olivia Bennett.
A person's department in Microsoft 365 is a field on their profile in Microsoft Entra. Apps read it, so it has to be right when someone moves. This guide changes Olivia Bennett from Sales to Emergency Department, along with her job title, and checks the saved values.
The All users list in the Microsoft Entra admin center shows names and sign-in names, but not people's job titles or departments, or whether they can sign in. Manage view → Edit columns adds those columns, so you can check a whole team on one screen instead of opening each person.
I added a time to a date with =B6+TIME(1,0,0) and Excel showed 29/03/2026, with no 01:00. The time was in the cell: its Date format just didn't show times. Excel for the web's Number Format list has no date-and-time option, but the custom format dd/mm/yyyy hh:mm shows both.
I added up a timesheet's Time worked column with SUM and got 12:15. The shifts came to 60 hours 15 minutes. The total was right, but its format, hh:mm, shows a time of day, so it dropped every whole 24 hours. The custom format [h]:mm shows 60:15.
To turn each shift's time worked into decimal hours, I multiplied it by 24. Excel showed 12:00, 00:00 and 18:00 instead of 3.5, 4 and 3.75. The numbers were right. The new column had picked up a time format, and switching it to Number fixed it.
In my overtime timesheet, =[@Finish]-[@Start] gave the right hours for every daytime shift and ######## for every shift that ended after midnight. Those subtractions came out negative, and Excel can't show a negative time. Wrapping the subtraction in MOD(…, 1) fixed it.
I pasted fourteen rows of overtime into Excel for the web, and the whole Date column turned into ########. Nothing was wrong with the dates: the column was too narrow to show them, and AutoFit Column Width fixed it in one click.
When I changed a user's manager in the Microsoft Entra admin center, ticking the new manager gave me Only 1 item can be selected, and Select went grey. The old manager was still in the Selected list. Removing them with the bin icon next to their name cleared the message.
