is it excel (microsoft)mistake about time calculating?

D

defnemotel

i ve list of time like that 18:20 , 18:40, 19:00 changing every 20
minutes. theese are column heads. and now i want to call these datas
under time columns compare with same time another sheet.
it works with all other times except 21:00, 03:00, 06:00.

i tried every kind of format but it doesnt resulted . please help me
 
R

Roger Govier

Hi

It could be that although the cell format is showing those cells as
21:00, the underlying value might be 21:00:01.

Try
=TIME(HOUR(Sheet1!A1),MINUTE(Sheet1!A1),0)=TIME(HOUR(Sheet2!A1),MINUTE(Sheet2!A1),0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suming Up Time over the course of days 1
Calculate minutes in different time zones 2
time problem or excel mistake 1
show with messaje box when it's time and date 1
Hours and minutes within/outside interval 15
how do i get the hours between these times?? 5
Subtracting hours and minutes with negative times 2
Conditional Time Calculation 10

Top