| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate duration day +1
How can I define the end of the next starting from a cell content dd/mm/yyyy
hh:mm for exemple Start time 15/05/2007 08:20 I need to define the value of the day +1 meaning 16/05/2007 24:00 Thanks you Marc |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate duration day +1
Hi Marc
You can't have 16/05/2007 24:00 as it would be 17/05/2007 00:00 Try =INT(A1)+1+"23:59:59" -- Regards Roger Govier "Marc S." wrote in message ... How can I define the end of the next starting from a cell content dd/mm/yyyy hh:mm for exemple Start time 15/05/2007 08:20 I need to define the value of the day +1 meaning 16/05/2007 24:00 Thanks you Marc |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate duration day +1
=INT(A1+2) ?
-- David Biddulph "Marc S." wrote in message ... How can I define the end of the next starting from a cell content dd/mm/yyyy hh:mm for exemple Start time 15/05/2007 08:20 I need to define the value of the day +1 meaning 16/05/2007 24:00 Thanks you Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| How can I calculate a value using time duration in mins & secs | Excel Worksheet Functions | |||
| Calculate duration in Excel 2000 | Excel Worksheet Functions | |||
| Calculate Duration. | Excel Discussion (Misc queries) | |||
| Duration | Excel Discussion (Misc queries) | |||
Hybrid Mode
