need help: time difference between two ceels in a column

G

Guest

Need to calculate the difference between two cells in a column. Exemple

A B C
Start 1 date/time
open date/time
: date/time
: date/time
: :
Start2 date/time =date2/time2 -date1/time1 (HH:MM)

I can select two consecutive "Start cells" with "IF"s, but the max of "IF"
supported by Excel is 7. I have no solution if there are more than 7 lines
between tho consecutive "start"s (or any other like "open" etc..)

I'd be glad to get some help.

68magnolia71 (in france)
 
B

Bernie Deitrick

68magnolia71,

See my response to your post in the worksheet.functions group.

Bernie
 

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

time differences in a column 7
Time and Date 2
Difference between date and time 7
Sum values in a column depending on start time in another column 5
Conditional Difference between two dates 2
time and date difference 6
Trying to calculate difference between two times in an access repo 1
date and time in 2 cells to create subtraction in 3rd 2

Top