הזנת שעות

[Alex Ashin]

האם יש דרך להזין שעות ללא נקודותיים ובלי צורך במאקרו או שימוש בפונקציות

 

[mole999]

from Hebrew

Is there a way to enter hours without a colon and without the need for macro or use functions

 

[Jon von der Heyden]

Shalom

No, not if what you want to enter is a genuine time serial value. You can enter whole numbers, but then formula would be required to convert to time serial value.

E.g.: 15 entered in A1 (to represent 15 hours)

As a time serial value would be converted as:

=A1/24

Hope this helps.

 

[Macropod]

Since time serial values are just decimals (where 1 second = 1/86400 = 1.1574074074074074074074074074074e-5), if you know what the decimal equivalent of the time is, you could enter that. Not for the faint-hearted, though.

 

[Alex Ashin]

No, thanks anyway,
Regards,
Alex

 

[Alex Ashin]

Hi Jon von der Heyden,
Thanks for your answer and for the "Shalom".
I solved it by using left and right functions but I hoped maybe there is a way that doesn't require extra column.
Regards,
Alex