On Monday 02 October 2006 01:12 am, | dMK | dINZO wrote: > 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
I had no problem getting a positive 8:00 for the time difference between 17:00 Monday and 01:00 Tuesday. It may well be all in the formating of the cells. I formatted all three cells as Time and 13:37. I am not sure about your problem with merging cells. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]