Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help: time difference between two ceels in a column
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) |
#2
|
|||
|
|||
68magnolia71,
See my response to your post in the worksheet.functions group. Bernie "68magnolia71" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |