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
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
144
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!