The peso has been the currency of Colombia since 1810. It replaced the real at a rate of 1 peso = 8 reales and was initially subdivided into 8 reales. In 1847, Colombia decimalized and the peso was subdivided into ten reales, each of 10 dÃ©cimos de reales.
Problems displaying a calculating negative time in excel 2007. I have a start time of 13:00, end time of 14:00 and a 120 minute break which gives me a negative block time of 1hr (used to forecast attrition). formula in e1: =HOUR(D1) + MINUTE(D1)/60 should return -1.00 which then allows me to calculate for cost.
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.