Tech Support banner

Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
1 Posts
Discussion Starter #1 (Edited)
Hi, My Excel question/problem goes like this...

On sheet 1 I enter a time in column A Row 2. If the time is AM I want it to go to sheet 2 column B row 3, but if it is PM, I want sheet 3 column B row 3. Also if column B row 3 on sheet 2 has a time in it, then it should also move over to column C row 2 and column D row 2 from sheet 1. How do I do this?:upset: :confused:
 

·
Registered
Joined
·
51 Posts
Ok, I'm not entirely sure if this is what you want but here's my attempt:
1. Format all the relevant cells as AM/PM time
2. Put in sheet 2 B3 =IF(Sheet1!A2<0.5,Sheet1!A2,"")
3. Put in sheet 3 B3 =IF(Sheet1!A2>=0.5,Sheet1!A2,"")
4. Now just reference the two duplicate cells to sheet 2 B3
That should work, you might need to turn on auto-calculation. Do you mind if I ask what it's for? It might be something that can be done more simply using Visual Basic, which I have some experience with. Let me know. Hope it works out anyway!
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top