Read time formatted cell in VBA

[VBA-Noob]

Hi,
I have an big problem! When I want to read the time from an time formatted cell it instead of 07:45:00 it Excel reads it as 0,322.....

This is the script I use:

If Range("Z1") > "" Then
...............
..............
..............
.............

I'm greateful for all help I can got!

Thanks!

 

[VoG]

Times in Excel are just numbers formatted in a special way. 24 hours equals 1. So 07:45 = 0.322.

 

[VBA-Noob]

Times in Excel are just numbers formatted in a special way. 24 hours equals 1. So 07:45 = 0.322.

Hi and thanks for ur reply. Ok, I understand but still how can I solve the problem?

 

[VoG]

What do you want to do with the time?

 

[Teeroy]

As VoG implied, the decimal is just a fraction of a day. If you want that number formatted as time try (if time is in A1):

debug.print format(range("A1"),"hh:mm:ss")

 

[VBA-Noob]

As VoG implied, the decimal is just a fraction of a day. If you want that number formatted as time try (if time is in A1):

debug.print format(range("A1"),"hh:mm:ss")

Hi,

Thank you so much, but where schould I place this function? Inside the If-statement och before?

Sorry but Im newbegginner.

 

[Teeroy]

That simply shows the time value as a time which was your initial request. You need to supply more information about what you are trying to achieve. You mention an If statement but what is the criteria? If you are comparing against a time, say 12pm, then you could use

If Range("Z1") > 0.5 then '12/24 =0.5 
...
End  If

 

[VBA-Noob]

That simply shows the time value as a time which was your initial request. You need to supply more information about what you are trying to achieve. You mention an If statement but what is the criteria? If you are comparing against a time, say 12pm, then you could use

If Range("Z1") > 0.5 then '12/24 =0.5 
...
End  If

Thank you man. Does it matters If I use european time, like 23:00:00

 

[Teeroy]

Excel just considers that to be 23/24=0.95833 formatted in a specific way. No matter what format the time is displayed in (23:00:00, 11:00:00pm etc.) there is no difference to the underlying number.