convert dd/mm/yy hh:mm AM IST
 

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.

convert dd/mm/yy hh:mm AM IST
 

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.

convert dd/mm/yy hh:mm AM IST
 

=--LEFT(A2,LEN(A2)-4) is one way of getting rid of the "IST"
Format the result as date and time.
--
David Biddulph

David Biddulph wrote:
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.
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.