Excel - reset / replace seconds to zero [Solved/Closed]

Report
Posts
1
Registration date
Tuesday April 7, 2009
Status
Member
Last seen
April 8, 2009
-
 safy_al_nya -
Hello,
i have an Excel 2007 file which has in sheet1 the time people enter to the system with the format ex. 11:55:31 AM and i need to reset all the seconds to zero
in sheet2 i have column with all the time start from 0:00:00 to 23:59:00 (seconds always zero) and i need to count for each time how many people enter to the system depends on the time which in sheet1

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
213
Suppose you have data in Sheet1!CellA1:A36. Now in Sheet two Column A write 0:00:00 to 23:59:00 values ....... now in sheet2!B1 write this formula ... =COUNTIF(Sheet1!$A$1:$A$100,"<="&A2)-COUNTIF(Sheet1!$A$1:$A$100,"<="&A1)

Copy this formula downward to get result ..... if any things confuse please attach the file ......
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

thank you very much for your effort