If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Negative time should be allowed in Excel, eg time difference
If you want to subtract two time values, it shows error if negative.
It would be an interesting feature e.g. for sports. Also, allow years before 1900 to be shown. ---------------- 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 |
#3
|
|||
|
|||
Hi
I think Bob meant =B1-A1+(A1B1)*24 assuming Finish Time in B1 and Start time in A1 The formula posted will return 10:00 hours in both cases where A1=23:00 and B1=13:00, and A1=13:00, B1=23:00 as opposed to 14:00 hours and 10:00 hours respectively. or you could use the less intuitive =MOD((B1-A1),1) Regards Roger Govier Bob Phillips wrote: You cater for it =IF(A1B1,A1-B1,B1-A1) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I calculate and show negative time in Excel? | Ramonak | Worksheet Functions | 1 | September 7th, 2005 01:54 AM |
Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
How do i enter negative times in Excel & how can they be 'fiddled. | stuck! | General Discussion | 2 | April 7th, 2005 02:05 PM |
WHY | General Discussion | 9 | December 16th, 2004 12:49 AM | |
Excel Formula Help please | Seventh Day is The Sabbath | Worksheet Functions | 3 | May 22nd, 2004 10:54 AM |