Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: Works 7



Gilbert,
It is true that 1hr & 59 mins after 11pm is 59mins after midnight i.e. 0:59.
Are you just trying to add time such as time taken i.e. 23hrs to do a job,
plus 1hr 59mins another day = 24hrs 59mins.
In excel this can be achieved by using the custom format [hh]:mm, but that
is not available in Works.
Barbara.

"Gilbert Bryon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> I use Works7 spreadsheet. My problem  is time calculation.
>
>     23:00
>  +   0:59
> ----------
>     23:59 ok      but   23:00 + 1:59 = 0:59 in works7, after 24:00 the
> calculatien is wrong.
>
> Wat the formule to arrive a      24:59 please
>
> thanks
>
> Gilbert Bryon
>
>
>
>





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.