开发者

Calculate time in Excel

开发者 https://www.devze.com 2022-12-28 18:59 出处:网络
i have two columns in xl sheet A row have this format \"8:25 PM EDT\" and B row have this format \"10:12:15 AM\" , Now i want to add one hour to the B column if the A c开发者_Go百科olumn contains the

i have two columns in xl sheet A row have this format "8:25 PM EDT" and B row have this format "10:12:15 AM" , Now i want to add one hour to the B column if the A c开发者_Go百科olumn contains the text "EDT" , Please help me to find out the solution Thanks in advance.


edited: IFERROR(IF(FIND("EDT",A1)>0,B1+TIME(1,0,0)),A1)

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号