
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
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__ --> |