On Monday, 21 August 2017 12:46:15 UTC+5:30, Max wrote:
On Thursday, 17 August 2017 19:23:36 UTC+5:30, Claus Busch wrote:
Hi Max,

Am Thu, 17 Aug 2017 06:50:39 -0700 (PDT) schrieb Max:

Thank You Very much Dear and heartily appreciate your prompt reply on solving my problem...

you are welcome.
Have another look in OneDrive. I changed all text values to numbers.


Regards
Claus B.
--
Windows10
Office 2016

Thanks Clause....for your help as now the reporting from HR is much easier now on... One More Question (As I am more interested in Excel and Learning the Formulas... Is there any way to retrieve only time from the full date and time value... i.e I want to retrieve only hh:mm "10:50" from full value like dd-mm-yyyy hh:mm:ss "07-08-1970 10:50:00" ?