[prev in list] [next in list] [prev in thread] [next in thread] 

List:       openoffice-users
Subject:    Re: [users] Trouble adding hours past 24 in calc
From:       Eike Rathke <erl () sun ! com>
Date:       2002-02-27 13:20:09
Message-ID: 20020227132009.GF32540 () staroffice-news ! Germany ! Sun ! COM
[Download RAW message or body]

Hi M.,

On Mon, Feb 25, 2002 at 14:05:31 -0800, M. Thomas Frederiksen wrote:

> I'm trying to use calc as a time sheet.  The trouble
> I'm having is adding hours past 24.  I set the cell
> format to [HH]:MM but I'm still getting the first 24
> hrs trucated. Any thoughts?

How do you add hours?

A1: 16:00
A2: 10:00
A3: =A1+A2

A3 displays 26:00 now if [HH]:MM is used.

Note that hours are fractions of a day, with 12 hours being 0.5 days.
This might be important if you calculate hours in a different way than
shown above.

  Eike

-- 
 Eike Rathke, Software Engineer, OpenOffice.org Calc core developer.
 Number formatter bedevilled I18N transpositionizer.
 PGP key 0xDA620A55: 01 53 0B 6F E3 37 08 47  E2 A0 6A 63 C1 3E 8B 96
 .project: char*(*(*foo())[])()

[prev in list] [next in list] [prev in thread] [next in thread]