Amend code to work with time instead of date

[chrisellis250]

Hi all,

I have the following code, which builds a table and imports the data from another tab:

Please Login or Register  to view this content.

Re the Date variable it currently works with Date in Column A of another Worksheet.

Obviously for it to work with time I need to make changes around Dt to Tm, but I am unsure how to declare Time as a variable.

The time will be a range, so in each cell it is displayed as 07:30 - 08:00, 08:00 - 08:30 etc etc.

Any ideas?

[Greg M]

Hi there,

Please Login or Register  to view this content.

You can declare a time value as being of type Date. (That's what I usually do anyway )

Regards,

Greg M

[chrisellis250]

Hi Greg,

Thanks for your response.

If I change my code from date to time it doesn't work, so I'm thinking I need to declare time as variable then run my data through.

[Greg M]

Hi again,

I'm probably misunderstanding your requirements, but I was referring to something like:

Please Login or Register  to view this content.

Even though the variable is declared as type Date it will accept a Time value, e.g.:

Please Login or Register  to view this content.

Does this help?

Regards,

Greg M

[LJMetzger]

Understanding the bits and bytes of Dates and Time.

Excel stores Dates and Times internally as a real number type Double which is similar to type Date.

The Integer Part of the 'real number' is the Date (number of days since a 'Base Date').
The fractional Part of the 'real number' the Time of Day.

For example:

Please Login or Register  to view this content.

Lewis