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

Question

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

Report

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

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

Excel - reset / replace seconds to zero
Excel - negative result equals to zero - How-To - Excel
Excel reset cell formatting - How-To - Excel
Excel macro replace cell value - How-To - Excel
Excel count exclude zero and blank ✓ - Forum - Excel
Excel - Hide rows with zero value in Multiple sheets - How-To - Excel

2 replies

Answer 2 / 2

safy_al_nya
Apr 16, 2009 at 12:55 PM

thank you very much for your effort

Ask a question

mubashir aziz · Accepted Answer · 2009-04-13T03:44:11-0400

Answer 1 / 2

mubashir aziz

Posts: 190
Registration date: Sunday April 12, 2009
Status: Member
Last seen: February 16, 2010

144
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 ......

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

2 replies

Your reply

Subscribe To Our Newsletter!