| 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
_________________________________________________________________
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]
It depends in part on how you have formatted the cells. For example,
if in cell A1, you enter "10/01/2006 17:00" without the quotes
(note the space after the 2006) and in cell A2 you enter "10/02/2006 01:30"
without the quotes then in cell A3 you simply put the formula =A2-A1 you
will get the time 08:30 if you format cell A3 as time using the second
time format choice of 13:37:46.
| 10/01/06 05:00 PM |
| 10/02/06 01:30 AM |
| 08:30:00 |
HTH.
|
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
