Excel - reset / replace seconds to zero
Solved/Closed
safy_al_nya
Posts
1
Registration date
Tuesday April 7, 2009
Status
Member
Last seen
April 8, 2009
-
Apr 8, 2009 at 05:38 AM
safy_al_nya - Apr 16, 2009 at 12:55 PM
safy_al_nya - Apr 16, 2009 at 12:55 PM
Related:
- Excel - reset / replace seconds to zero
- Samsung keypad reset code - Guide
- Battery reset code - Guide
- How to reset windows 10 password without logging in - Guide
- How to reset forgotten password on lenovo laptop without disk - Guide
- Ubuntu reset network settings - Guide
2 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
Apr 13, 2009 at 03:44 AM
Apr 13, 2009 at 03:44 AM
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 ......
Copy this formula downward to get result ..... if any things confuse please attach the file ......