Excel - reset / replace seconds to zero
Solved/Closed
safy_al_nya
safy_al_nya - Apr 16, 2009 at 12:55 PM
- Posts
- 1
- Registration date
- Tuesday April 7, 2009
- Status
- Member
- Last seen
- April 8, 2009
safy_al_nya - Apr 16, 2009 at 12:55 PM
Related:
- Excel - reset / replace seconds to zero
- Excel - negative result equals to zero - How-To - Excel
- Excel vba replace blank cells with text ✓ - Forum - Programming
- Excel count exclude zero and blank ✓ - Forum - Excel
- Excel if blank or zero - Forum - Excel
- Excel - Don't display zero if result is null - How-To - Excel
2 replies
mubashir aziz
Apr 13, 2009 at 03:44 AM
- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010
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 ......