How to change the columns a formula will get its data from
Here is a dummy example of what my spreadsheet looks like, the end date/time can be in different columns based on external factors. a b c d 1 Start date/time Other date/time End date/time Amount of time 2 January 1 2026 12:41:55 PM January 1 2026 12:50:00 PM 3 January 1 2026 3:30:50 PM January 2 2026 5:00:00 PM 4 January 2 2026 4:00:55 PM January 2 2026 10:00:00 PM 5 January 13 2026 12:30:00 PM January 13 2026 12:33:00 PM How do I calculate the difference in time in column D based when the end date and time may be in one of two columns? Before I would just subtract one column from another and then format the cells to create a readable output automatically, but I need a formula to take into account two columns and to choose the one that is not empty. I am unsure how to write the in then else in a way that Excel can understand. What I have tried: = IF c2 = " " THEN b2-a2 ELSE c2-a2Shared Calendars No Longer Visible
For years, I've shared Outlook calendars between my Outlook accounts and with my husband's, without any issues. However, since mid-June the shared calendars have disappeared for no apparent reason. The sharing permissions are still in place, but the calendars are no longer visible or available to add on Android, in the Outlook desktop app, or on Outlook on the web. I've spent hours Googling and tried all the usual troubleshooting steps, but nothing has worked! As a workaround, I now have to invite all @outlook.com accounts to calendar events just so everyone can see them and avoid double bookings. Has anyone come across this before and found a fix that isn't one of the standard "how-to" suggestions? Note: these are personal paid Microsoft accounts.
New Outlook: "Changing the ImapRemoteServerInfo is not allowed" after host migration
Hi everyone! I've migrated my domain/mailbox from one IMAP host to another in May. It cannot be added to New Outlook for Windows — fails instantly with INVALID_CREDENTIALS INTERACTION_REQUIRED, even when I deliberately enter a wrong password (so it's failing before authentication is even attempted). Using DevTools (olk.exe -devtools), the Network tab shows the real rejection from Microsoft's backend: Changing the ImapRemoteServerInfo is not allowed. Attempted to change it from imap.olddomain.sk to imap.newdomain.sk So New Outlook has a cloud-mailbox / connected-account shadow record for this address, pinned to the old host from a previous add attempt, and the backend refuses to update it. What I've confirmed: Webmail and a second mailbox on the same domain/host both work fine → not credentials, not the host. The account does not appear in Settings → Accounts (so I can't use "Remove from all devices" which worked on my first account). It's on no other device or client. App reset didn't help (record is server-side, not local). It's been ~7 weeks, so any 30-day inactivity purge hasn't cleared it How do I get this stuck cloud-mailbox / connected-account record purged when it isn't attached to any removable account? Is there a way to force it, or does this need Microsoft backend action?Fixes in Microsoft Access - Version 2610 (Build 16.0.20527.20088)
Known issue in the initial Version 2610 release Some databases may display an incorrect "There isn't enough memory or disk space" message when opening a report or exporting a report to PDF. A correction is planned for the next Version 2610 update. UPDATE: This issue is now fixed in build 16.0.20527.20112. Use 'Update Now' to update to the new build. Zoom Issue Fix Datasheet subforms did not zoom with Ctrl+mouse wheel Using Ctrl+mouse wheel over a subform displayed in Datasheet View now changes its zoom level as expected. Context menus appeared in the wrong location on zoomed forms Right-click menus now open at the selected location regardless of the form's zoom level, including near the lower-right edge of the form. A form divider line could stop halfway across at 50% zoom The divider between form sections now spans the full form width at 50% zoom and other supported zoom levels. Rapid Ctrl+mouse-wheel input could jump from 10% to 1000% zoom Zooming out quickly now stops at the 10% minimum instead of wrapping to the maximum zoom level. Big Forms Issue Fix Horizontal scrolling could snap very wide forms back to the left Design View and Form View can now scroll to controls positioned far to the right without the form unexpectedly returning to its left edge. Text formatting remained limited to 22 inches in wider controls Text can now be formatted and displayed across the full width of fixed-size text controls wider than the former 22-inch form limit. Forms and controls Issue Fix ControlTip text could remain visible after typing began ControlTips now close when keyboard input begins, preventing the tip from covering the form during data entry. Property Sheet text could become unreadable after changing the Office theme The Property Sheet now refreshes both its foreground and background colors immediately after a theme change, without requiring Access to be restarted. Queries and data Issue Fix Bracketed object and control names could occasionally be read incorrectly Access now reliably preserves a name when removing its surrounding brackets. Stability Issue Fix Opening forms with grouped control layouts could cause Access to close unexpectedly Access no longer closes unexpectedly while determining the bounds of grouped layouts when affected forms open in Form View. Changing a subform's SourceObject could cause Access to close unexpectedly Changing a subform's source from VBA during an event now completes without causing Access to close unexpectedly.
OneDrive Personal Folder closes fast
WIN11 OneDrive 26.198.1011.0006 Since one week I am having issues accessing my Peronal Folder in OneDrive. The Peronal Folder in OneDrive when opened is closing withing 1 minute. I already uninstalled and re-installed OneDrive without any success. Did the Reset as recommended inseveral website I am GOOGLING. Does anyone has a suggestion how to fix this issue. It makes Peronal Folder in OneDrive unusable.
No acces to local Office365 apps with an account which differs from the current windows account
Hi, guys! I'm working with Windows 11 Pro using the Microsoft account ABC. Today I bought a Office 365 Family License - by using another Microsoft account XYZ. I downloaded the local apps successfully... ...but when I start the local app and tried to sign in using the XYZ account, I'm asked for the Windows Hello Pin for the XYZ account - but there is no PIN for that, because the account doesn't exist as a Windows account at this computer at all. Copilot says: "You can sign in to Windows 11 with one Microsoft account and use a different Microsoft 365/Office account for Office applications. Microsoft supports this setup." What did I wrong - what can I do? Kind regards! Sebastian
