hiii,,, can any one tell me the excel formula to calculate late comers and also who leaves early in one cell,, please help me ,,, Regrads Shariff
From India, Bangalore
1From India, Bangalore
hiiii,, can any one tell me the excel formula to calculate late comers and also who leaves early in one cell please mail me Rgds Shariff
From India, Bangalore
From India, Bangalore
Hi Shariff,
As I don't have any work in my office today and I just opened citehr.com and saw your question. Even I too don't know how to calculate timings in excel , but searched some formula-es in internet and tried my self and I was successful. To calculate- who leaves early and late login , first you find the difference between login(A column) and logout(B column). Just Subtract Logout(B column) time with login(A column) time. you will get the difference there. And easily can recognize there who is not staying around 9hrs per day.
But there is small problem there.
If logout(B column) time islessthen(<) login(A column) time then it's shows all #####, then use these this formula in excel
isequalto if(B<A,B+1,B)-A . Sure will u get the difference.
If you don't want to see AM/PM in those column , just right click and format cells, select h:mm:ss
if any have doubt get me again
Regards,
Santosh
From India, Hyderabad
As I don't have any work in my office today and I just opened citehr.com and saw your question. Even I too don't know how to calculate timings in excel , but searched some formula-es in internet and tried my self and I was successful. To calculate- who leaves early and late login , first you find the difference between login(A column) and logout(B column). Just Subtract Logout(B column) time with login(A column) time. you will get the difference there. And easily can recognize there who is not staying around 9hrs per day.
But there is small problem there.
If logout(B column) time islessthen(<) login(A column) time then it's shows all #####, then use these this formula in excel
isequalto if(B<A,B+1,B)-A . Sure will u get the difference.
If you don't want to see AM/PM in those column , just right click and format cells, select h:mm:ss
if any have doubt get me again
Regards,
Santosh
From India, Hyderabad
Hi,, Santhosh,,
Thank you very much for your reply and concern,, hmm i tried the formula but again i am getting an error,, ok ,, i tell what exactly i want to,,,
Actual office working hours is 09:30am to 06:00pm,,ok
emp :09:40log in 05:45log out
in this log in coloumn with help general formula i can make out late comers ,but when emp log in time is enetred by 09:20 it shows an error and same case in log out time coloumn also i can make out who leave early but again when time is entered after 06:00 again error ,,, please help me about from 3 days i am trying this i am not getting it,,please help me
Regards
Shariff
From India, Bangalore
Thank you very much for your reply and concern,, hmm i tried the formula but again i am getting an error,, ok ,, i tell what exactly i want to,,,
Actual office working hours is 09:30am to 06:00pm,,ok
emp :09:40log in 05:45log out
in this log in coloumn with help general formula i can make out late comers ,but when emp log in time is enetred by 09:20 it shows an error and same case in log out time coloumn also i can make out who leave early but again when time is entered after 06:00 again error ,,, please help me about from 3 days i am trying this i am not getting it,,please help me
Regards
Shariff
From India, Bangalore
hiii Santhosh,,,
i need two formula for two cells i,e log in coloumn and other one is logout coloumn,, i want to know late log in and early log in ,,,
and other coloumn early log out and late log out also,.,,,.
please
From India, Bangalore
i need two formula for two cells i,e log in coloumn and other one is logout coloumn,, i want to know late log in and early log in ,,,
and other coloumn early log out and late log out also,.,,,.
please
From India, Bangalore
Hi Shariff,
I have calculated some formula-es as per your questions in the attached excel sheet. Let me know if you have any doubts further and any questions regarding formula_es in the attached excels.
And if you have any errors in maintaining and calculating the timings , please share those login time and log out time. so that i can help you out more in detail.
And also say me how is the attachment , because I have prepared that document for you itself.
Regards,
Santosh
From India, Hyderabad
I have calculated some formula-es as per your questions in the attached excel sheet. Let me know if you have any doubts further and any questions regarding formula_es in the attached excels.
And if you have any errors in maintaining and calculating the timings , please share those login time and log out time. so that i can help you out more in detail.
And also say me how is the attachment , because I have prepared that document for you itself.
Regards,
Santosh
From India, Hyderabad
Hi Santhosh ,,,
Firstly Thank you, what i want is i am not getting it so see the attachment and get it please ,,,,,
And attachment is very good it is so simple anyone can understand it ,,, in that formating of cell in red and green that idea very good excellent,,,, But Santhosh Bhai go through the attachment and help me please,,, pleaseeeeee,,,,,
Thanks&Regards
Shariff
From India, Bangalore
Firstly Thank you, what i want is i am not getting it so see the attachment and get it please ,,,,,
And attachment is very good it is so simple anyone can understand it ,,, in that formating of cell in red and green that idea very good excellent,,,, But Santhosh Bhai go through the attachment and help me please,,, pleaseeeeee,,,,,
Thanks&Regards
Shariff
From India, Bangalore
open the excel sheet, click on windows button(at the right top of the excel) click on that, and click on save as and select excel 97-2003 wook book and save. and try to upload that file. sure you will able to..
Regards,
Santosh
From India, Hyderabad
Regards,
Santosh
From India, Hyderabad
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
MS-EXCEL - INTRODUCTION TO PIVOT TABLES.pdf
The wonders of Ms excel.zip