After midnight
Good deal. Thanks for feeding back!
--
Biff
Microsoft Excel MVP
"Steved" wrote in message
...
Hello Biff
Thankyou I formulated the cell wrongly I forgot to check, I thankyou
Now that I've looked how the cell was formatted , all is fine.
Cheers
Steved
"T. Valko" wrote:
Not sure what you're asking.
You're adding 32 minutes to the value of cell F20.
If F20 = 11:29 PM the formula returns 12:01 AM which is correct.
--
Biff
Microsoft Excel MVP
"Steved" wrote in message
...
Hello from Steve Dee
What is required to the below to go past midnight.
=F20+TIME(0,32,0)
Thankyou
|