Am trying to automate production report email process.
In this process, I have to read total production of each member and need to highlight which are lagging behind standard time.
I am able to read “10:30:39” from excel using generic value but not able to convert back to time to do computation.
Now i need to highlight values which are below “10:30:00”. Because of reading it as generic it shows some thing like 0.53453455.
Any Idea ?