If you need to add a number of payroll time entries together, change the time format to a number format, then perform your calculations. Open a new Microsoft Excel 2010 spreadsheet.

Now, in the Number group in the Home tab on the ribbon, click the "Number Format" drop-down menu, and select "Time." By ...

The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

Excel Tip No. 1: Automatically SUM() with ALT + = Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in ...

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above. 5. Logic for number formatting ...