Google Spreadsheet Post #1133
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 16, 2013
user Kailasam Manickam :(http://productforums.google.com/forum/?zx=kaquw4uxiqns#!mydiscussions/docs/2U-osz4jEFM)
Countif based on time
I am trying to prepare on line attendance tracking system for my company. I have herewith given link to my spreadsheet. Please view it.
In the monthly Sheet (Apr) I want to have no. of Late comings after (10:15 am but should not count 7 pm out timing ) and late sitting ( After 7 PM) against each staffs. Also I would like to have summary of all these for all the months ( from Jan to Dec) in the roll sheet against each name.
I have done for other factors like no. of leaves, Offs, OD etc. But I am not able count the no.of late comings and late sittings (Column BP to BW).
The today sheet will show the summary for the day.
Thank you very much for responding my query.
With Regards,
M Kailasam
---
Sorry Yogi,
I have forgotten to add the link.
Here it is
----------------------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment