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.
As you can see I wanted to calculate how much time elapsed between 8:30 AM and 10:30 PM by subtracting the 8:30 start time value in cell A2 from the 10:30 PM end time in cell B2. The start and stop times were entered with AM and PM formats.y default, Excel applied the AM/PM format to the result and returned 2:00 PM which is 14:00 on a 24 hour clock. So it calculated the correct answer â 14 hours of elapsed time â but I want to display that answer in hours and minutes.