Hi Shariq

I'm not entirely sure I understand what you want, but if you have a
time value in a cell, you could format it (custom format that is) as:

hh

which would only display the hours of the timevalue, so if the full
time was say 15:32:00 it would display

15

Alternatively, if you want the time value as an integer (ie for the
number of hours) perhaps you could use:

=INT(A1*24)

where A1 holds your time.

Hope this helps!

Richard


Shariq wrote:
Hi !
How can I change the time, which if changed to a decimal number, but gives a
figure of 1,02 for an hour, but is there any function that can produce result
as just (1)