LEFT Function

[UpTheArgyle]

Hi I have a cell formatted as a time - so "A1" is 18:04:20 - (4 minutes past 6pm)

What i want to do use the LEFT function in cell "B2" so as i only have the number representing the actual hour, in this case 6pm - this is so i can pivot table by hour of the day and ignore seconds and minutes.

Using this - =LEFT(A1,2) i get a result of "0."

Any ideas?

Thanks

 

[VoG]

Try

=HOUR(A1)

 

[Richard Schollar]

Use the Hour function:

=HOUR(A1)

 

[Aladin Akyurek]

Hi I have a cell formatted as a time - so "A1" is 18:04:20 - (4 minutes past 6pm)

What i want to do use the LEFT function in cell "B2" so as i only have the number representing the actual hour, in this case 6pm - this is so i can pivot table by hour of the day and ignore seconds and minutes.

Using this - =LEFT(A1,2) i get a result of "0."

Any ideas?

Thanks

=HOUR(A1)

would work better.

I believe PT can organize the data by year, month, but also by hour.

 

[Richard Schollar]

Incidentally, rather than using a separate column, you should be able to Group on this Date field within the Pivot Table itself (without using a separate formula column) and group on Hours. Right-click on the Date row field and select Group & Show Detail>Group