Dear Friends, Open attachment and calculate employee age simply Jitendra Patel Gujarat
From India, Mahesana
From India, Mahesana
Really Nice Calculator....
May i have the same calculation method to estimate employee's No.of Hours worked per day, if we capture it in excel.
Because we put time-in and time-out for Morning and Afternoon sessions.
If so, it would be helpful for us..
Thank you....
From India, Tirupati
May i have the same calculation method to estimate employee's No.of Hours worked per day, if we capture it in excel.
Because we put time-in and time-out for Morning and Afternoon sessions.
If so, it would be helpful for us..
Thank you....
From India, Tirupati
Dear Jitendra,
Very nice work done. Its very useful.
But at the same time you must inform to all citehr members that the format of date is mm/dd/yyyy and not dd/mm/yyyy.
Initially I also faced the same problem when I entered in dd/mm/yyyy.
Regards,
MS
From Saudi Arabia, Riyadh
Very nice work done. Its very useful.
But at the same time you must inform to all citehr members that the format of date is mm/dd/yyyy and not dd/mm/yyyy.
Initially I also faced the same problem when I entered in dd/mm/yyyy.
Regards,
MS
From Saudi Arabia, Riyadh
This is awesome,but would welcome a worksheet with the possiblity of containing more than 500 staff info. with age calculation determinant opprtunity in a giffy.
From Nigeria
From Nigeria
Dear Jitendrabhai,
Thank you for sharing such a wonderful thing with us. Much appreciated.
Dear CiteHR members,
The problem few of us are facing is with the "Date Format". Actually the format of the date is not something that can be mentioned.
Our system catches the date format on the way how we have set it in our control panel of our computer.
I have my default date format set as DD/MM/YYYY, hence this format worked for me as opposed to MM/DD/YYYY. I get error if I mention the later format.
Hope the format of the date is no longer a confusion for all of us. :)
From India, Mumbai
Thank you for sharing such a wonderful thing with us. Much appreciated.
Dear CiteHR members,
The problem few of us are facing is with the "Date Format". Actually the format of the date is not something that can be mentioned.
Our system catches the date format on the way how we have set it in our control panel of our computer.
I have my default date format set as DD/MM/YYYY, hence this format worked for me as opposed to MM/DD/YYYY. I get error if I mention the later format.
Hope the format of the date is no longer a confusion for all of us. :)
From India, Mumbai
hi, jitendra does not open in correnct excell sheetDear Friends, Open attachment and calculate employee age simply Jitendra Patel Gujarat
From India, New Delhi
From India, New Delhi
Hi Jetendra, Nice one. could you assist with unprotecting the sheet or any other way of copying the columns as it is not getting copied. Regards, Abhijit
From India, New Delhi
From India, New Delhi
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.
Add the url of this thread if you want to cite this discussion.
#Subject List: pf account pf number placement agencies manufacturing company manufacturing industry City-India-Mahesana Country-India