Pivot Talbe and Number Format to Time not working

[zubair009]

Hi,

Problem: Chart does not show Pavit table data time format even if i change time format to hh:mm
still it shows in am / pm formats.


i want to show time format on chart as 24 hours like


02:00
03:00
04:00
14:00
15:00
21:00


I have two columns of time as one is TimeIn and 2nd is TimeOut

some times working and some times not working some time not working.

even if you can advise vba no problem it would be good in respect of time formats.
worksheet is attached for your review and advise.

how do I share my workbook here ?

 

[Andrew Poulsom]

What number format have you applied to the field in the pivot table?

You can put your workbook on a share like Box.com and post the URL.

 

[zubair009]

https://app.box.com/s/u89268a7s4ns9r2jjp1n


Thanks for your immediate reply and sharing advice.

here is the workbook

 

[Andrew Poulsom]

If you have blanks in the source data you can't apply a number format to the field.

 

[zubair009]

I will try thanks.

 

[zubair009]

Thanks a lot for pin pointing my problem in a short time. you are a Star.

Thanks & regards