Calculate Difference in Sequential Dates in One Date Field

Existing Data Structure is as under:

**Requirement:**

A formula is required to calculate the total duration an Employee spent in a particular grade and branch.

The value is to be entered in a separate columns called 'Duration in Grade' and 'Duration in Branch'

I guess a conditional DATEDIF should meet the requirement.

Thanks in Advance

Regards

Existing Data Structure is as under:

Sl | Name | Grade | Branch | Date | Remarks | Duration in Grade | Duration in Branch |

1 | Employee A | Grade 2 | Branch 1 | 12-04-2015 | 464 | 1081 | |

2 | Employee B | Grade 2 | Branch 2 | 12-04-2015 | |||

3 | Employee C | Grade 2 | Branch 3 | 12-04-2016 | |||

4 | Employee A | Grade 3 | Branch 1 | 18-07-2016 | Upgradation | 618 | 1081 |

5 | Employee A | Grade 4 | Branch 3 | 28-03-2018 | Upgradation & Transfer | 942 | 440 |

6 | Employee B | Grade 2 | Branch 1 | 12-04-2015 | |||

7 | Employee A | Grade 4 | Branch 6 | 11-06-2019 | Transfer | 502 |

A formula is required to calculate the total duration an Employee spent in a particular grade and branch.

The value is to be entered in a separate columns called 'Duration in Grade' and 'Duration in Branch'

I guess a conditional DATEDIF should meet the requirement.

Thanks in Advance

Regards

hello,

i think i'm doing something wrong, as i have 6 columns with different numbers from 0-20.

i want to add a formula to calculate from all the cells, if the cell value is above 10 or below 10, but only the difference. for better understanding i attach the file.

the values represent a tire depth of a truck. i want to see in the end, how many tires are above 10 and with what amount. also, how many are below 10, and what is the value

can somebody help me pls ?

i think i'm doing something wrong, as i have 6 columns with different numbers from 0-20.

i want to add a formula to calculate from all the cells, if the cell value is above 10 or below 10, but only the difference. for better understanding i attach the file.

the values represent a tire depth of a truck. i want to see in the end, how many tires are above 10 and with what amount. also, how many are below 10, and what is the value

can somebody help me pls ?

I am trying to make cash flow statement for a real estate project where the payments are staggered and are paid based on % completion of the project.

I have attached an example sheet for reference.

Is it possible to do the calculation without using any other cell for storing shortfall amounts?

Thank you in advance.

I have attached an example sheet for reference.

Is it possible to do the calculation without using any other cell for storing shortfall amounts?

Thank you in advance.

Hi all, anybody know how I can

link column A with column B? | ||||||||

I would like to use the codes in column B in different sheets. | ||||||||

For example if I type B5, I would like cells in other workshheets to automatically | ||||||||

fill in the corresponding data from D5, E5, F5, G5, H5, I5 and J5 | ||||||||

Ps What would I need to do if I insert/delete 1 more person or pet so that the formulas | ||||||||

get inserted/deleted automatically as well | ||||||||

Thanks a lot!! |

Attached is my project for searching a table. I've tried using the Index(), the Match(), and the Vlookup(); but I'm getting frustrated trying to get these to work. Please help.

I'm using Excel 2019.

My Project.xlsm

I'm using Excel 2019.

My Project.xlsm

The owner of a very small business wants his employees to log their worked hours electronically. (At this time they do not have a web site). He has set up a form on a shared drive that collects the data and store it in a sheet in the following format:

He also has a sheet containing formulas for pay calculation and needs to transfer the data to the appropriate cells on that sheet. The payroll sheet is set up in the following format:

I am a fairly good excel user but this is beyond me. I have tried INDEX/MATCH formulas, nesting VLOOKUP and IF/VLOOKUP but cannot get one that works. I need to be able to get the IN and OUT time for each employee for the date worked.

This is not the best or most efficient way of managing this process but it's the one my client has for now. Can anyone help?

He also has a sheet containing formulas for pay calculation and needs to transfer the data to the appropriate cells on that sheet. The payroll sheet is set up in the following format:

I am a fairly good excel user but this is beyond me. I have tried INDEX/MATCH formulas, nesting VLOOKUP and IF/VLOOKUP but cannot get one that works. I need to be able to get the IN and OUT time for each employee for the date worked.

This is not the best or most efficient way of managing this process but it's the one my client has for now. Can anyone help?

I want to autofill cells from one sheet within a workbook based on a specific criteria

Example:

Located on sheet 1 in Cell A1 I enter "Store 1"

Located on Sheet 2 in cells A1:A20 are the names of the 5 sales people for Store 1

On sheet 1 I want all the sales people to populate in cells C1:C5 automatically when sheet 1, cell A1 contains "Store 1"

I am using the following formula but it only returns the first name in the list

={IF(A1="Store 1",Sheet2!A1:A20,0)}

Thanks in advance for any insight

Tim

]]>Example:

Located on sheet 1 in Cell A1 I enter "Store 1"

Located on Sheet 2 in cells A1:A20 are the names of the 5 sales people for Store 1

On sheet 1 I want all the sales people to populate in cells C1:C5 automatically when sheet 1, cell A1 contains "Store 1"

I am using the following formula but it only returns the first name in the list

={IF(A1="Store 1",Sheet2!A1:A20,0)}

Thanks in advance for any insight

Tim

I have the same number in multiple rows and I'm looking to add _A, _B, _C, etc. to the end of each cell to make them unique. Does anyone know what formula I could use for something like this? The formula I've tried is substitute(address(1,rows(a$1:A1),4),1,"") but all i end up with is "A" rather than "12345_A"

]]>I am trying to enter the following formula,

=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$49,"")))))

however when I get to

=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$

From this point I cannot enter anymore info as the computer wont let me, I have tried copying and pasting it to no avail

Any thoughts

]]>=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$49,"")))))

however when I get to

=IF($B$4='Gate items'!$F$3,'Gate items'!$B$4:$B$10,IF($B$4='Gate items'!$F$4,'Gate items'!$B$16:$B$19,IF($B$4='Gate items'!$F$5,'Gate items'!$B$28:$B$33,IF($B$4='Gate items'!$F$6,'Gate items'!$B$40:$B$45, IF($B$4='Gate items'!$F$7,'Gate items'!$B$

From this point I cannot enter anymore info as the computer wont let me, I have tried copying and pasting it to no avail

Any thoughts