Thread: After midnight
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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