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. 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!
