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.
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.