I can not get my formulas to work as I need when the date/time passes past midnight.
=IF($B40<'TIME BLOCKS (2)'!DF40,0,IF($B40>'TIME BLOCKS (3)'!DF40,0,1))
10/18/09 8:00 PM
10/19/09 4:00 AM
This works well until the time span passes midnight.
http://www.excelforum.com/attachment...cel-forum.xlsx
Last edited by ed ayers315; 10-23-2009 at 04:45 PM. Reason: Was able to upload an example file
Hi,
What's in B40 & D40 on both the sheets, and what result are you expecting and why?
It would help if you could upload a sample workbook so that we can see the request in context.
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I tried to upload the files but received an error message "missing security token"
I'll try to upload on this reply
I zipped the file and it still would not uplaod
Excel keeps track of dates as integers. Today is 40105 in excel time. Tomorrow will be 40106. To keep track of the time, it uses decimal parts of those integers. For example, maybe righ now is 40105.637429..., but in an hour it will be 40105.71268... So if you are using the < and > operators, you are actually comparing numbers. Thus tomorrow at 1:00 AM is still greater than today at 10:00 PM.
Could that have something to do with your problem?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
I wish I could upload the file; that would help to solve my problem.
Thanks for the try!
Last edited by ed ayers315; 10-22-2009 at 10:50 AM. Reason: Uploaded Example File
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks