KÄmakalÄ KÄlÄ« is like the redness at dawn, like red hibiscus. Her eyes are like Cuckoo bird and appear like jambul fruit (Jamun or jambu). Hair is thick and long, reaching her feet. Her three eyes appear like burning coals. Her face is like a full moon and a red lotus.
Setting Cells to Have the [h]:mm Format: 1  Right click on the cell to be formatted. 2  Select the option Format Cells... 3  Ensure the Number tab is selected in the window that pops up. 4  Select the option Custom from the list of Categories and type [h]:mm into the box on the right. 5  Click OK.ell B3 of the following spreadsheet shows a simple example of how to calculate a time difference in Excel. The calculation simply subtracts the time in cell B1 from the time in cell B2.
Step 2. Enter the title Total Hours in cell C1. Select cell C2 by clicking on it with your mouse. Related Reading: Various Count Functions in Excel. Step 3. Enter the formula =B2-A2 and press the Enter key to display the time difference between two cells.Change the cell format to hours by selecting the cell and clicking on the arrow next to the Number option, which is on the Home tab.tep 4. Count the total number of hours worked based on a single time unit by entering the formula =INT((B2-A2)*24) and then pressing the Enter key. The INT function enables you to count the total number of hours between two times and round down the total to the nearest hour.