Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
excelent,
Can you post the problem you are getting? some people may not wish to download attachments, it might be better to try and explain what problem you are getting Duncan excelent wrote: Hi fellows can sombody figure this out ? :-) http://pmexcelent.dk/Mappe11.xls Excel 2003 DK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
ok ill try
timevalues in A2:A20 timevalue in B2:B20 A2 and A3 is put in manual all values is put in manual then rest is fill/copy down A2=00:02 B2=00:02 A3=00:03 B3=00:03 and so on then formatted as numbers with 19 decimals as u can c they r not equal all the vay down? A B 0,0013888888888888900 0,0013888888888888900 0,0020833333333333300 0,0020833333333333300 0,0027777777777777700 0,0027777777777777800 0,0034722222222222200 0,0034722222222222200 0,0041666666666666600 0,0041666666666666700 0,0048611111111111100 0,0048611111111111100 0,0055555555555555500 0,0055555555555555600 0,0062500000000000000 0,0062500000000000000 0,0069444444444444400 0,0069444444444444400 0,0076388888888888800 0,0076388888888888900 0,0083333333333333300 0,0083333333333333300 0,0090277777777777700 0,0090277777777777800 0,0097222222222222200 0,0097222222222222200 0,0104166666666667000 0,0104166666666667000 0,0111111111111111000 0,0111111111111111000 0,0118055555555555000 0,0118055555555556000 0,0125000000000000000 0,0125000000000000000 0,0131944444444444000 0,0131944444444444000 0,0138888888888888000 0,0138888888888889000 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
excelent:
Im afraid I cannot replicate your problem, when I try it the numbers all match? When you are putting in as timevalues, which format?, is it singular H with square brackets? ([h]:mm:ss) Duncan excelent wrote: ok ill try timevalues in A2:A20 timevalue in B2:B20 A2 and A3 is put in manual all values is put in manual then rest is fill/copy down A2=00:02 B2=00:02 A3=00:03 B3=00:03 and so on then formatted as numbers with 19 decimals as u can c they r not equal all the vay down? A B 0,0013888888888888900 0,0013888888888888900 0,0020833333333333300 0,0020833333333333300 0,0027777777777777700 0,0027777777777777800 0,0034722222222222200 0,0034722222222222200 0,0041666666666666600 0,0041666666666666700 0,0048611111111111100 0,0048611111111111100 0,0055555555555555500 0,0055555555555555600 0,0062500000000000000 0,0062500000000000000 0,0069444444444444400 0,0069444444444444400 0,0076388888888888800 0,0076388888888888900 0,0083333333333333300 0,0083333333333333300 0,0090277777777777700 0,0090277777777777800 0,0097222222222222200 0,0097222222222222200 0,0104166666666667000 0,0104166666666667000 0,0111111111111111000 0,0111111111111111000 0,0118055555555555000 0,0118055555555556000 0,0125000000000000000 0,0125000000000000000 0,0131944444444444000 0,0131944444444444000 0,0138888888888888000 0,0138888888888889000 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
when i start all cells is formatted as standard
then i put directly 00:02 ENTER and Excell format this as hh:mm did u try put in manualy all times in 1 column and in the other column use fill/copy handle ? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
Yep,
used the fill/copy handle and have tried various ways of formatting to replicate your error to no avail.... confusing....! Try using the format I suggested above (bracketed single H) and let me know if you still get this problem Duncan excelent wrote: when i start all cells is formatted as standard then i put directly 00:02 ENTER and Excell format this as hh:mm did u try put in manualy all times in 1 column and in the other column use fill/copy handle ? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
hi Duncan i got this tip
http://support.microsoft.com/kb/211830/en-us I think that vil help :-) tanks for ur time "Duncan" skrev: |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
I already reply to this post on other forum...
You should use ROUND function to round both values of dates and everything will work... Problem is because excel uses floating point for date/time "excelent" wrote in message ... ok ill try timevalues in A2:A20 timevalue in B2:B20 A2 and A3 is put in manual all values is put in manual then rest is fill/copy down A2=00:02 B2=00:02 A3=00:03 B3=00:03 and so on then formatted as numbers with 19 decimals as u can c they r not equal all the vay down? A B 0,0013888888888888900 0,0013888888888888900 0,0020833333333333300 0,0020833333333333300 0,0027777777777777700 0,0027777777777777800 0,0034722222222222200 0,0034722222222222200 0,0041666666666666600 0,0041666666666666700 0,0048611111111111100 0,0048611111111111100 0,0055555555555555500 0,0055555555555555600 0,0062500000000000000 0,0062500000000000000 0,0069444444444444400 0,0069444444444444400 0,0076388888888888800 0,0076388888888888900 0,0083333333333333300 0,0083333333333333300 0,0090277777777777700 0,0090277777777777800 0,0097222222222222200 0,0097222222222222200 0,0104166666666667000 0,0104166666666667000 0,0111111111111111000 0,0111111111111111000 0,0118055555555555000 0,0118055555555556000 0,0125000000000000000 0,0125000000000000000 0,0131944444444444000 0,0131944444444444000 0,0138888888888888000 0,0138888888888889000 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
#N/A error matching time values
excel uses 10 decimals for time/date but, as I've used this, when using
ROUND function I'm rounding to 5 decimals and everything is OK. It's, I belive, best way,.... Much better than use something you found on Microsoft KB article.. "excelent" wrote in message ... ok ill try timevalues in A2:A20 timevalue in B2:B20 A2 and A3 is put in manual all values is put in manual then rest is fill/copy down A2=00:02 B2=00:02 A3=00:03 B3=00:03 and so on then formatted as numbers with 19 decimals as u can c they r not equal all the vay down? A B 0,0013888888888888900 0,0013888888888888900 0,0020833333333333300 0,0020833333333333300 0,0027777777777777700 0,0027777777777777800 0,0034722222222222200 0,0034722222222222200 0,0041666666666666600 0,0041666666666666700 0,0048611111111111100 0,0048611111111111100 0,0055555555555555500 0,0055555555555555600 0,0062500000000000000 0,0062500000000000000 0,0069444444444444400 0,0069444444444444400 0,0076388888888888800 0,0076388888888888900 0,0083333333333333300 0,0083333333333333300 0,0090277777777777700 0,0090277777777777800 0,0097222222222222200 0,0097222222222222200 0,0104166666666667000 0,0104166666666667000 0,0111111111111111000 0,0111111111111111000 0,0118055555555555000 0,0118055555555556000 0,0125000000000000000 0,0125000000000000000 0,0131944444444444000 0,0131944444444444000 0,0138888888888888000 0,0138888888888889000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
#N/A errors when matching time values | Excel Worksheet Functions | |||
error calculating negativ difference time values | Excel Programming | |||
VBA, matching values and time synchronizing | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming |