Calculate duration day +1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date and time difference 19
Calculate the duration between the end time and start time of anot 4
Peak call times/hours 2
calculate cells with format hh:mm 4
Time query 9
Finding dates without attention to data formats 1
Format duration in mm/dd hh:mm 3
Getting MM-DD HH:MM out of Julian date 4

Back
Top