Hi Guys, long time no see!
My query today is to ask for help with the following: I am allocated to put through transport requests for staff at my company. All our shifts are saved onto a spreadsheet as per example below. What I need is a formula to check the shift in cell B2, compare it to a list of shifts, and "print" the required end time into the (seperate) transport sheet under the appropriate name. I have tried an IF function, but it is only returning 7pm (even with later shifts)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]13/01/2016[/TD]
[TD]14/01/2016[/TD]
[TD]15/012016[/TD]
[/TR]
[TR]
[TD]Joe Soap[/TD]
[TD]10-7[/TD]
[TD]1-10[/TD]
[TD]Day Off[/TD]
[/TR]
[TR]
[TD]Jack Sparrow[/TD]
[TD]11-8[/TD]
[TD]12-9[/TD]
[TD]Leave[/TD]
[/TR]
</tbody>[/TABLE]
My query today is to ask for help with the following: I am allocated to put through transport requests for staff at my company. All our shifts are saved onto a spreadsheet as per example below. What I need is a formula to check the shift in cell B2, compare it to a list of shifts, and "print" the required end time into the (seperate) transport sheet under the appropriate name. I have tried an IF function, but it is only returning 7pm (even with later shifts)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]13/01/2016[/TD]
[TD]14/01/2016[/TD]
[TD]15/012016[/TD]
[/TR]
[TR]
[TD]Joe Soap[/TD]
[TD]10-7[/TD]
[TD]1-10[/TD]
[TD]Day Off[/TD]
[/TR]
[TR]
[TD]Jack Sparrow[/TD]
[TD]11-8[/TD]
[TD]12-9[/TD]
[TD]Leave[/TD]
[/TR]
</tbody>[/TABLE]