Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
date & time formulas HELP !!
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Jackpot, post: 6451165"] 04/07/2010 15:00:00 is bigger than 04/07/2010 00:00:00 Try 04/07/2010 23:59:59 in A1 and 00:00:01 in cell B1 and try formula A1+B1 04/07/2010 23:59:59 is followed by 04/08/2010 00:00:00 So the below formula should work fine. =B1-A1 and format the formula cell to [h]:mm:ss [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
date & time formulas HELP !!
Top
