| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel 2007 bug in difference between time
From 11 AM to 6:30 PM is 7 Hours and 30 Minutes. Or subtracting 11
hours from 18 hours and 30 minutes leaves 7 hours and 30 minutes. Please re-examine expectations. Jon wrote: I've created a simple worksheet to return the difference between two times, however, the first time is being reported incorrectly by 2 hours. B2 - 11:00 C2 - 18:30 D2 - =C2-B2 MS Excel 2007 The result of D2 is returned as 07:30, whilst this should read 05:30. This problem does not happen with another cell. Am I using some incorrect formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtract the time difference from another time difference | Excel Discussion (Misc queries) | |||
| Difference in dates in Excel 2007 | New Users to Excel | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
Threaded Mode
