Excel - reset / replace seconds to zero
Solved/Closed
safy_al_nya
Posts
1
Registration date
Tuesday 7 April 2009
Status
Member
Last seen
8 April 2009
-
8 Apr 2009 à 05:38
safy_al_nya - 16 Apr 2009 à 12:55
safy_al_nya - 16 Apr 2009 à 12:55
Related:
- Excel - reset / replace seconds to zero
- Excel mod apk for pc - Download - Spreadsheets
- How to reset ps3 controller - Guide
- Replace abbreviation - Guide
- Battery reset code - Guide
- Samsung duos reset password - Guide
2 responses
mubashir aziz
Posts
190
Registration date
Sunday 12 April 2009
Status
Member
Last seen
16 February 2010
166
13 Apr 2009 à 03:44
13 Apr 2009 à 03:44
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 ......
