After midnight
 

Hello from Steve Dee

What is required to the below to go past midnight.

=F20+TIME(0,32,0)

Thankyou

After midnight
 

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

After midnight
 

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

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