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
Configuration: Windows XP Internet Explorer 7.0
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)
|
Change screen resolution shortcut windows 7 Excel count the second most number of values in a cell Excel not have a zero for cells equal to another cell Find and replace function in excel Find same text in 2 column and replace all duplicate text function in excel Hide row in excel using function How to replace ink cartridge in lexmark x3650 How to replace top shell of ds lite Mini display to vga windows resolution Replace acer laptop mouse Replacing hard drive in hp dv2000 Rest two dates in excel Restore toshiba satellite factory settings Samsung star t9 reset Why does my computer come up with a blue screen and restart Why does my computer keep saying (not responding)? Windows live messenger automatically sign out after few seconds Windows reset password on second partition