|13 Nov 2012||#1|
| || |
Excel custom formula Help
I use microsoft excel 2012 and am quite familiar with how to use the software.....
I need a custom formula which will do the following :
Take a custom formula field (05/11/2012 08:59:07) its a custom field type but the only thing im interested in is the time .....
Then write a function which sorts all those that are after **:10:00 past the hour but before **:29:00 , and then again filter for **:40:00 and then before **:59:59 ... and place them in a column next to the field im sorting .
Ive tried an IF Statement but it does not work......
Could i consider conditional formatting and then highlighting the cells i want to key in on ...between the times
|My System Specs|
|Similar help and support threads for2: Excel custom formula Help|
|Excel 2003 Suddenly Stopped Responding to Formula Changes||Microsoft Office|
|Formula 1 '97||Gaming|
|Excel 2003 sum formula problem||Microsoft Office|
|Want to copy data and formula from one Excel Sheet to another.||Microsoft Office|
|Excel Formula Help please...||Microsoft Office|
|excel syntax problem for formula... difference in days||Microsoft Office|
|Cant scroll while editing formula Excel 2007||Microsoft Office|