Time

[jeh]

Hi

Thanks to all who have helped me so far.

I have labels that are on a userform that will report the average of 60 minutes of data. I have 24 cells that I want to pull the data from.

What I hope some one will tell me is how to I set up a way of getting the right data for the right hour?

The first hour will be from 00:00 to 01:00.
I want the data drom A1. After 01:00 up until 02:00, I want the data from cell A2.

Can this be done in a way that a rookie like me can understand?

Thank you for your time,

Jim

 

[waderw]

Do you know VB or are you familiar with VBE?

 

[jeh]

I'm familiar with the VBE, but I don't know how to write VB. for the most part I record macros and hack them up pretty bad. And I can usually stumble through putting code where it works any way.

 

[Legacy 98055]

Jim
Is the crieria based upon the current time?
In any case, it seems that the Select Case Statement might be the best way to go...
If you only need the data from one cell you could also try this, assuming the hour is the current hour...

lblYourLabel.Caption = _
Sheet1.Range("A" & Hour(Now) + 1).Value

Tom

 

[jeh]

Thanks alot Tom. I never thought of that.

Jim