Account Options

  1. Sign in
The old Google Groups will be going away soon.
Switch to the new Google Groups.
Google Groups Home
« Groups Home
microsoft.public.excel.misc
+ new post
About this group
Subscribe to this group
This is a Usenet group - learn more
Negative Hours and Minutes
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   4 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
Amanda Barnes  
View profile  
 More options May 15 2002, 9:54 am
Newsgroups: microsoft.public.excel.misc
From: "Amanda Barnes" <amanda.bar...@bt.com>
Date: Wed, 15 May 2002 14:54:17 +0100
Local: Wed, May 15 2002 9:54 am
Subject: Negative Hours and Minutes
Print | Individual message | Show original | Report this message | Find messages by this author
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?


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Peo Sjoblom  
View profile  
 More options May 15 2002, 10:25 am
Newsgroups: microsoft.public.excel.misc
From: "Peo Sjoblom" <terr...@mvps.org>
Date: Wed, 15 May 2002 10:23:52 -0400
Local: Wed, May 15 2002 10:23 am
Subject: Re: Negative Hours and Minutes
Print | Individual message | Show original | Report this message | Find messages by this author
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


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Vasant Nanavati  
View profile  
 More options May 15 2002, 10:31 am
Newsgroups: microsoft.public.excel.misc
From: "Vasant Nanavati" <vasa...@aol.com>
Date: Wed, 15 May 2002 10:30:24 -0400
Local: Wed, May 15 2002 10:30 am
Subject: Re: Negative Hours and Minutes
Print | Individual message | Show original | Report this message | Find messages by this author
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.bar...@bt.com> wrote in message

news:abtpjn$ip7$1@pheidippides.axion.bt.co.uk...


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Amanda Barnes  
View profile  
 More options May 15 2002, 11:47 am
Newsgroups: microsoft.public.excel.misc
From: "Amanda Barnes" <amanda.bar...@bt.com>
Date: Wed, 15 May 2002 16:47:21 +0100
Local: Wed, May 15 2002 11:47 am
Subject: Re: Negative Hours and Minutes
Print | Individual message | Show original | Report this message | Find messages by this author
Thank you everyone!
"Amanda Barnes" <amanda.bar...@bt.com> wrote in message

news:abtpjn$ip7$1@pheidippides.axion.bt.co.uk...


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google