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.
For the time 02:30:30, the formula in cell B2 of the above spreadsheet returns the value 150.5. Ie. 2 hours 30 minutes and 30 seconds is equal to 150.5 minutes. The same result can also be obtained using the Excel Hour, Minute and Second functions, as shown in the spreadsheet below: Again, the formula in cell B2 of the above spreadsheet returns the value 150.5.