Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Negative Hours and Minutes

0 views
Skip to first unread message

Amanda Barnes

unread,
May 15, 2002, 9:54:17 AM5/15/02
to
Two cells - both custom formatted, [h]:mm to allow cumulative hours and mins
e.g 37:45

I can add them togather and take one from the other, but if this produces a
minus I get ############## ???

I want to be able to do something like this:-
35:50 - 37:00 = -01:10

Can anyone tell me how I can do this?


Peo Sjoblom

unread,
May 15, 2002, 10:23:52 AM5/15/02
to
Amanda,

to do that you either have to change the date system, tools>options>calculation, and check
1904 date system, note that 4 years and 1 day will be added to all present dates, or you can
convert the hours to decimals by multiplying by 24

=(A3-A4)*24

where A3 holds 35:50 and A4 37:00


--

Regards,


Peo Sjoblom


"Amanda Barnes" <amanda...@bt.com> wrote in message news:abtpjn$ip7$1...@pheidippides.axion.bt.co.uk...

Vasant Nanavati

unread,
May 15, 2002, 10:30:24 AM5/15/02
to
Hi Amanda:

You can either (1) switch to the 1904 date system using <Tools>
<Options> or (2) write a custom function The former approach will throw
off any existing dates in the workbook, I believe by 1462 days.
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**

"Amanda Barnes" <amanda...@bt.com> wrote in message
news:abtpjn$ip7$1...@pheidippides.axion.bt.co.uk...

Amanda Barnes

unread,
May 15, 2002, 11:47:21 AM5/15/02
to
Thank you everyone!

"Amanda Barnes" <amanda...@bt.com> wrote in message
news:abtpjn$ip7$1...@pheidippides.axion.bt.co.uk...
0 new messages