convert dd/mm/yy hh:mm AM IST

R

Rajesh Palande

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.
 
D

David Biddulph

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.
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Netwrokdays in VBA 1
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
Difference between two date/time values 6
HELP! I need to make an IF Statement comparing date/time fields.. 2
Time query 9
Splitting dd/mm/yyyy hh:mm 2
Formula convert date to month format 7
Peak call times/hours 2

Top