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
|
|||
|
|||
Hour and Minute Differences
6:52 is correct. Why should it be 6:32?
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Supriya " wrote in message ... Cell A1=11/02/2004(dd/mm/yyyy) A2=11/02/2004(dd/mm/yyyy) B1=18:30(hh:mm) B2=11:38(hh:mm)formats Now C1=(A1+B1)-(A2+B2) which shows the result as 6:52(hh:mm), which in fact should be 6:32(hh:mm) What is the problem? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|