ExcelBanter - Calculate duration day +1

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculate duration day +1 (https://www.excelbanter.com/excel-worksheet-functions/143843-re-calculate-duration-day-1-a.html)

vezerid

Calculate duration day +1

On May 23, 4:28 pm, Marc S. wrote:
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

=CEILING(A1,1)

HTH
Kostis Vezerides

All times are GMT +1. The time now is 04:13 PM.