Category Archives: Lizzy

Share or transfer autocorrect (acl) files

Technet entry

 

To use your AutoCorrect entries on another computer (or to share them with another user profile on your computer), locate the .acl files in the %AppData%\Microsoft\Office folder. (You can type the path in Windows Explorer exactly as shown here and the %AppData% environment variable will automatically expand to the full path. In Windows 7, that path is C:\Users\username\AppData\Roaming\Microsoft\Office by default, but it might be different on your computer.)

Copy the two .acl files to the comparable folder on another computer or in another user’s profile.

Adding hours, minutes, and seconds in Excel 2016

This took some figuring out! Set the cells that you will be using for the calculation in the custom [h]:mm:ss format from the drop-down menu at the top of the window. Enter the numbers, making sure to put 0’s if the value is blank.

i.e. 12 hours, 5 seconds = 12:00:05

Complete the SUM function to calculate the total of the times, making sure that the result cell is also in the [h]:mm:ss format.

Things that don’t work:

Subtracting. Normally you just use the SUM function and include negative numbers to subtract them, but excel won’t accept the negative times.

60+ minutes or seconds. It just freaks out and won’t do it. You can have over 12 or 24 hours, though.

 

Further reference: Microsoft support

If you’re not liking this honestly pretty bad tool, this one can subtract more easily: Browser Time Calculator