Try..IF(E4<>"","".. insted E4>0,0..since 0 is not in time format, its given
such display...
Thanks!!
On Mon, Jul 8, 2013 at 3:33 PM, vba wrote:
> Pl share excel file.
>
> Thanks
>
>
> On Mon, Jul 8, 2013 at 3:18 PM, Ashish Kumar wrote:
>
>> Dear Seniors,
>>
>> When I'hve put the data, the outp
Pl share excel file.
Thanks
On Mon, Jul 8, 2013 at 3:18 PM, Ashish Kumar wrote:
> Dear Seniors,
>
> When I'hve put the data, the output is reflected #, but i want data in
> numbers (Time). please see attached snapshot for more clarity. kindly help
> me on this.
>
>
> Thanks
> Ashish
>
> --
