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]
