MarkAndrews
Well-known Member
- Joined
- May 2, 2006
- Messages
- 1,970
- Office Version
- 2010
- Platform
- Windows
I have a long list of data, formatted Date (dd/mm/yy) & time
Whats the best way to get rid of the time (Text to columns?) & still keep the date?
I need to perform networkdays on the date with another column
Sample below
TIA
Whats the best way to get rid of the time (Text to columns?) & still keep the date?
I need to perform networkdays on the date with another column
Sample below
TIA
Abort Data.xls | ||||||
---|---|---|---|---|---|---|
F | G | H | I | |||
4 | 2/8/0612:13 | |||||
Jan |