![]() |
#1
|
|||
|
|||
![]()
I hope this is something that Excel is capable of doing.
I have a set of data (time in minutes) below (fig 1) that I need to use if the total time between two entered times matches a coloms total. If it matches I want Excel to use the data in that colom to affect the data in another (fig 2) colom adding the times to each cell. Looking at both figs. below I want Row B, Colom A in fig 2 to add Row A, Col A to Row A, Col A in fig 1 since both are the total of 19. fig 1 Coloms A B C D Row A 5 5 6 6 Row B 5 6 6 8 Row C 4 5 6 7 Row D 5 4 4 5 Total 19 20 23 26 fig 2 Coloms A B C D Row A 1:00 2:00 3:11 4:01 Row B Row C Row E Row F 1:19 2:20 3:33 4:27 Row F-A= 19 20 23 26 I can send an Excel file if it would help figuring this out. PLEASE PLEASE TELL ME THERE IS A SOLUTION |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
chesspupil | Excel | 2 | 04-16-2006 11:06 PM |
Entry point not found? | Zanmax | Outlook | 0 | 02-14-2006 06:26 AM |
Application not found error when trying to open .pdf files. | Dave | Outlook | 2 | 12-15-2005 01:01 PM |