Ms Excel - Xls Download - Excel Formula

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

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

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

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

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

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

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

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

atlast i have made it,, to upload the file ,,, Thanks a Lot

Hi Shariff,
Please find attached the excel sheet. I have given two solutions to calculate the early login timings and early log out timings.
And also I asked one question in that, so waiting for the answer to that question.
Regards,
Santosh