| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
After midnight
Hello from Steve Dee
What is required to the below to go past midnight. =F20+TIME(0,32,0) Thankyou |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Midnight will not display in cell | Excel Worksheet Functions | |||
| Time after midnight | Excel Worksheet Functions | |||
| time around midnight | Excel Worksheet Functions | |||
| mod formula used with midnight | Excel Worksheet Functions | |||
| subtraction off time after midnight | Excel Worksheet Functions | |||
Linear Mode
