| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add 24 hours to a date and time value formated cell?
I have a cell formatted with DD/MM/YY HH:MM in 24 hour clock and want to add
1 day or 24 hours. When I use the +time(24,0,0) function the date remains the same and the hours are only added. How do I get it to add a day to the date and time. I'm doing time zone convertions for 6 different world locations.. Tks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| Adding zero's to Time formated cell | Excel Worksheet Functions | |||
| Adding numbers to a Time Formated cell | Excel Discussion (Misc queries) | |||
| How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
Threaded Mode
