Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel custom formula Help


13 Nov 2012   #1

6bit windows 7
 
 
Excel custom formula Help

Hi all,
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

Thanks


My System SpecsSystem Spec
.

Reply

 Excel custom formula Help




Thread Tools



Similar help and support threads for2: Excel custom formula Help
Thread Forum
Excel 2003 Suddenly Stopped Responding to Formula Changes Microsoft Office
Formula 1 '97 Gaming
Solved Excel 2003 sum formula problem Microsoft Office
Solved 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

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:00 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33