开发者

Subtracting time from a date in Excel

开发者 https://www.devze.com 2023-03-05 06:11 出处:网络
I have a cell in column 3 that contains a datetime: 5/1开发者_如何学C2/2011 8:13AM. I\'m looking to subtract x hours from this time.

I have a cell in column 3 that contains a datetime: 5/1开发者_如何学C2/2011 8:13AM. I'm looking to subtract x hours from this time.

So far, I have this:

=A3-TIME(8,0,0)

It's not working. How should the formula be written?


Removed the space between 13 and AM.


Use DateAdd instead of voodoo/rolling your own.

0

精彩评论

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