To who it many concern Wondering about calulating time differences I looked for help on the help option offered on the Open Office Org. Spreadsheet programme.
On the help menu it states >If you want to calculate time differences, for example, the time between 23:30 >and 01:10 in the same night, use the following formula: =(B2<A2)+B2-A2 The later time is B2 and the earlier time is A2. The result of the example is 01:40 or 1 hour and 40 minutes. In the formula, an entire 24-hour day has a value of 1 and one hour has a value of 1/24. The logical value in parentheses is 0 or 1, corresponding to 0 or 24 hours. The result returned by the formula is automatically issued in time format due to the sequence of the operands.< The formula has worked for most cases when the time differences are within one day but the thing is when I calulate the time eg. Monday 1700 hrs to Tuesday 0100 hrs it comes back with a negative number. The answer is correct but I need it to be postive in order for my calculation to work. Is there a way to format the cells to only have postive numbers from the calulation? I would need these particular numbers to automatically appear to be a positive instead of a negative number. Another thing.... I merged 3 cells together. I tried using your speical fill eg. when typing in days I simply highlight across the cells concerned to automatically fill them in with the other days. A problem I exprience was that when I used the special fill the merged cells would simply split to the number of cells I earlier merged. I hope to hear from you soon. Johans _________________________________________________________________ Try Live.com: where your online world comes together - with news, sports, weather, and much more. http://www.live.com/getstarted --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
