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.
In Excel, time is stored as days, or fractions of a day. Since there are 24 hours in a day, 60 minutes in each hour, and 60 seconds in each minute, you need to divide by 24 * 60 * 60 = 86400 in order to convert decimal seconds to a value that Excel will recognize as time.Once you've done the conversion, you can apply a time format of your choice.Related formulas:f A1 contains the number 21600 (representing 21600 seconds) then the result will be 21600/21600 = .25, since 21600 minutes = 6 hours = 1/4 day. To see the result formatted in a normal time format, you'll need to change the number format to a time format.