Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
how do i show negative time in hours minutes | Excel Worksheet Functions | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) |