Hello from Steve Dee What is required to the below to go past midnight. =F20+TIME(0,32,0) Thankyou
S Steved Dec 11, 2007 #1 Hello from Steve Dee What is required to the below to go past midnight. =F20+TIME(0,32,0) Thankyou
T T. Valko Dec 11, 2007 #2 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.
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.
S Steved Dec 11, 2007 #3 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
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
