evaluate cell with time data to determine if error occured

[jetpack]

have sheet with column B receiving time stamp (m:d:yy h:m:ss)every second, which is copied to next row every second. every hour of elapsed time should amount to 3600(60*60) rows of data.

how can I check dynamically that each row has the correct time stamp and, if not, corresponding row in column A show where there is a missing time stamp?. trying to determine if there is missing data or if excel is skipping a beat now and then.

thanks for looking in, and I appreciate any help you can offer.

 

[GR00007]

Would having a flag in a new column work?
=IFERROR(IF(ROUNDDOWN(B2 - B1,5) = 0.00001,"","Interval not a second"),"Please check")

 

[jetpack]

works great, mate.

can it be made to check dynamically as each row is added?

really appreciate your help.

 

[GR00007]

Check this guy out and see if it meets your needs:
https://bettersolutions.com/excel/formulas/automatic-expansion.htm

 

[jetpack]

gud' day mate.

thanx for sharing the link, really appreciate you taking the time to help me out. it doesn't do what I need
but still very nice of you to go to the trouble.

thanx again.