开发者

Subtracting time from a date in Excel

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜