You'll need to trim the " IST" off the end, then hopefully you can get Excel
to recognise the rest as a real Excel date and time and do the usual Excel
processing. =MOD(cellref,1) will trim off the date and leave the time.
--
David Biddulph

Rajesh Palande wrote:
25/01/10 04:39 AM IST
I want to write a function which will compare the timing given in
format mentioned above with 04:10 pm or 16:10 hrs and highlight if
current time is more that 16:10. Please help me with appropriate
formula.