Thread: calculation with hours and minutes - input of negative values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default calculation with hours and minutes - input of negative values
=-(INT(50/24)+TIME(50,0,0))
or
=-INT(50/24)-TIME(50,0,0)

works ok for me.

But it's pretty ugly!

MichaelMichael wrote:

hi there,
i can calculate and, since i use the 1904 format for it, also with negative
values.
but still it is not possible to give an input of f.e. -50:00:00 means minus
50 hrs.
any solution for it?
regards
michael

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

--

Dave Peterson
Reply With QuoteReply With Quote