Basic Formulas in Excel. So below is the formula to calculate the actual working time. In this accelerated training youll learn how to use formulas to manipulate text work with dates and times lookup values with VLOOKUP and INDEX MATCH count and sum with criteria dynamically rank values and create dynamic ranges.
This process activates all the functions or formulas of excel.
The TIME function creates a date in serial number format from the hour minute and second components you specify. IFA2IFA2--330 PMYesNo into a blank cell where you want to locate the result B2 for instance and then drag the fill handle down to the cells that you want to apply this formula. We want to calculate their working hours by just subtracting the out time from the in time as you can see we have applied the simple subtraction formula in the cell. Type a plus sign then use your pointer to select C2 to enter the second cell reference into the formula.