Change time into decimel unit
Hi Richard!
I think I didn't put my querry right, actually I am using this formula to be
able to calculate time even if it is spent is less then 1 hrs,
=MAX(1,(E7-B7+(E7<B7))*24)
but now the outcome I receive is not in digit 1,00 but 1,04 and this is what
creates problem, because I need to multiply those hours spent into Amount,
and then it mutiplies not with 1 but with 1,04, so have you any clue how to
help this problem.
"RichardSchollar" wrote:
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)
|