Forum Discussion

VINCENTR's avatar
VINCENTR
New Member
5 years ago
Solved

Split hour colomn

Good day,

 

I want only the hours and not the minutes. How can i do this?

 

Thanks for your help

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    VINCENTR ,

    Try a new column like

    hour([time_move])

     

    or

     

    hour([time_move]) + minute([time_move]) /60 + second([time_move]) /3600

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    VINCENTR ,

    Try a new column like

    hour([time_move])

     

    or

     

    hour([time_move]) + minute([time_move]) /60 + second([time_move]) /3600