need help: time difference between two ceels in a column

6

68magnolia71

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 5
Calculating the difference, in hours, between two date/time in two different time zon 2
Difference between date and time 7
How to calculate difference between two date & time along with working hours and days 2
Time and Date 2
Formatting a spreadsheet to calculate difference in dates etc. 2
Calculating the difference between two dates and times 8
Trying to calculate difference between two times in an access repo 2

Top