from hh:mm:ss to hh:mm ?

[Ekser]

Hello!

I am struggling with this issue, it seemed to be a piece of cake but i
is not that obvious: I have data in format hh:mm:ss (08:12:51) and I'
like to have it in hh:mm (08:12), how to do this?!
I already tried to format the cell to custom [h]:mm but it doesn'
change anything to the selected cells!?


Thanks!



Eks

 

[Frank Kabel]

Hi
this sounds like your data is probably stored as 'Text'
(maybe you have importedt these values). Try the following:
1. What does the formula
=ISNUMBER(A1)
return. If it returns 'FALSE' then the values are stored
as text.

2. In this case try the following:
- select an empty cell
- copy this cell
- select your time values
- goto 'Edit - Paste Special' and choose 'Add'

After this changing the format to [h]:mm should work

 

[Ekser]

It works perfect!

Thank you so much! ;