Home |
Search |
Today's Posts |
#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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
Excel: Add time to a date and time column? | Excel Worksheet Functions | |||
Unix Time in Excel | Excel Worksheet Functions | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel |