Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of employees in the appropriate time column | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
Time axis column and scatter/line graph | Charts and Charting in Excel | |||
How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |