We help IT Professionals succeed at work.

EXCEL time/date

Stephen Byrom
on
383 Views
Last Modified: 2013-11-29
Hi,
Cell A1 shows the date and time using Now().
I wish a different cell to show that date minus 1 if the time is less than 08:05.
I have tried many permutations of datevalue and timevalue but i'm slowly losing the will to live.
Any help is greatly appreciated.
Comment
Watch Question

=IF(NOW()-TODAY()<TIME(8,5,0),-1,0)
Stephen ByromWarehouse/Shipping

Author

Commented:
Thanks for the speedy response Andrew.
If I place that formula in a cell it just shows lots of hash marks, no matter how large I make the cell or whatever format I change it to.
Is there a way to use the IF statement in the target cell?
Such as
IF cell A1 is less than time 08:05 then show yesterday's date and time, else show today's date and time

Thanks again
Can you attach your file here?  I will help to fix.
Stephen ByromWarehouse/Shipping

Author

Commented:
Ok.
This is still in it's embryo stage
Production.xlsm
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Okay! I dun know you dun know the basic function.  Sorry!  

Keep in touch!

Andrew
Stephen ByromWarehouse/Shipping

Author

Commented:
Thanks for your time Andrew (no pun intended)
As you can probably guess, I will be asking a few more questions on here before I finish that workbook :)
Good!  I can help you!

Keep in touch!

Andrew Man from Hong Kong
andrew.man@live.cn
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.