A Date & Time Cell

[Stenner]

Hi Al

I have a spreadsheet with two tabs. Both tabs have a Start Time column but the start time for the 2nd tab is determined by the first tab start time cell.

All the lines in tab 1 have either "Pre" or "Post" in them which is a criteria that needs to be met for the formula in the 2nd tab start time cell.

The current formula in the 1st tab on cell S48 is =S47+INT(T47/24)+TIME(T47,0,0)
S47= the date and time in the cell above
T47= the hours it takes for production

The result will come up with a cell looking like 12/06/2017 06:00

The 2nd tab start time cell must only pick up the lines with "Pre" in them from tab 1 and show the result like the above date and time.

I have tried an if formula but I couldn't get it to work. Any help would be much appreciated!

Rgds

Aarron

[FDibbins]

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Stenner]

Hi Ford

Thanks very much for your reply.

Attached is a mock workbook with the result I would like too.
On tab Machine 2 I need a formula that would pick up any line with Criteria Range, "Machine 1 Pre/Post", Criteria, "Pre" and give the result of the Start Time.

I appreciate any help!

Rgds

Aarron

[davsth]

in cell c2 put =INDEX('Machine 1'!$D$2:$D$9,MATCH("Pre"&B2,'Machine 1'!$B$2:$B$9&'Machine 1'!$C$2:$C$9,0)) and enter as an array with shift control enter

[Stenner]

Hi Davsth

It worked perfectly. Thank you!

Rgds

Aarron

[davsth]

If the question is answered, you should edit the title and mark the thread as solved. glad it worked!

[FDibbins]

If the question is answered, you should edit the title and mark the thread as solved. glad it worked!

No need to edit the title, just use the THREAD TOOLS just above the very 1st post, and mark it SOLVED there