need help: time difference between two ceels in a column

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
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
Finding MIN value in a column between Two Dates in different columns 3
Calculating the difference between two dates and times 7
Between Operator Works Differently 4
Sum values in a column depending on start time in another column 5
Calculate Holding Period Returns Between Two Customizable Dates 1

Back
Top