1. H

    Remove duplicate from list

    Hi there, I have 2 columns A and B column A has about 50 rows and column B has about 50 rows too. Some of the data appears in both column A and B, my aim is to get the data that are not duplicates and move them to column C, the data in the 2 fields does not directly match up from left to right...
  2. R

    Time Conversions Using Local To ZULU (24 hour time) while adding hours and minutes

    Hello, I am looking for some help creating a formula for 2 time conversions, and a Julian day converter. Please keep in mind I cannot us VBA due to workbook sharing. If you are aware of what this applies to, please keep that private. I work for the military and while it wouldnt be wise to...
  3. D

    Converting Zulu to Pacific time

    I have this Excel Spreadsheet that I have to submit everyday at work. The only thing I can't figure out is how to convert the zulu times into Hawaii time. Can someone please help me with a formula? Below is what I need it to look like. I can't take the zulu day out, I need the formula to...

Some videos you may like

This Week's Hot Topics