calculation with hours and minutes - input of negative values
 

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

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

calculation with hours and minutes - input of negative values
 

Thanks,
it works (after I found the german translation - english doesn't work with
this 2003 any more), but it is still not useful for endusers.
I use now f.e.

A1 = input cell, format [h]:mm
A2 = empty
A3 = A2-A1
A3 cell format is [h]:mm

but it is not very nice for using, because you cannot use one cell for + and
- values as the user just likes to put in the needed hours.
But it is possible, to use as a workaround.
Regards
Michael


"Dave Peterson" wrote:

=-(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