0

How to divide time by a number?

I'm hoping to find out how I can take a time interval (hours/minutes) and divide it by a number. 

E.g. - In a delivery company, I have 52 stops that have been completed in 6:52 hours. How do I have the database calculate the number of stops per hour?

2 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Hi Jonathan,

     

    You should first convert the time interval to a number

    ---

    number ('time interval').

    ---

    The result is in milliseconds. To convert this to hours:

    ---

    number (time interval) / 1000/60/60

    ---

    Number of stops per hour (Formula Field):

    ---
    let myNumber: = number (time interval) / 1000/60/60;
    Stops / myNumber
    ---

    regards

    Leo

    • jonathan
    • 5 yrs ago
    • Reported - view

    Thank you very much! That's exactly what I needed.

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1882Views