Hello Friends
Version : MS Excel 2010,
File Name : <time addition with AM and PM.xlsx>
From In time I want to add the 9 hours and accordingly AM / PM has to shown correctly.
Also the Afternoon time after 11:59 AM should be 12.00 PM and the midnight after 11:59 PM should be 00:00 AM.
I did a formula myself, please check the same (Correct it also) and tell me if any errors.
Also without adding any helper rows, helper columns, helper cells is it possible to reduce / simply the formula ?
thanks in advance
thilag
Bookmarks