Hello guys,
I'd like a cell to display the actual time only if this time is > than 11:59...
If it's before 11:59 AM the cell should display 11:59 AM
On CELL B9 I have a formula (NOW) that shows the actual time
My formula is: =IF[(B9<0,49336; B11=0,49336; NOW()] but it's not working...
I used the number to indicate the time and after i would change the format cell...
Thanks for your help
Bookmarks