Timevalue

 

I'm working on a project for an alert at a specific time.  I'm using Excel 2007.  I would like to see an alert, let's say at 0600.  The formula being used is:( ='mt4'|high!eurusd).  This gives me realtime data, but I don't know how to convert the timevalue.

Any help is appreciated. 

 
merl4:

I'm working on a project for an alert at a specific time.  I'm using Excel 2007.  I would like to see an alert, let's say at 0600.  The formula being used is:( ='mt4'|high!eurusd).  This gives me realtime data, but I don't know how to convert the timevalue.

Any help is appreciated. 

How to convert the time value in Excel ?  ask in an excel Forum.
Reason: