Forum Discussion

Nelz_'s avatar
Nelz_
Copper Contributor
Jan 18, 2021
Solved

Formula that shows units per minute '1904 date system'

Hi,   Need assistance with a couple formulas that can give me how many units per minute and hour. Not too sure how to explain it properly so I have attached a worksheet below which outline what I ...
excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    Jan 18, 2021

    Nelz_ 

     

    Perhaps

    Units/Min =[@[No. Units]]/([@[Arr vs Dep]]*1440)

    Units/Hr =[@[Units Per Minute]]*60

     

    In excel, time is measured in days. So, to convert a time to number of minutes you would multiply by 1440 mins/day. 

JMB17's avatar
JMB17
Bronze Contributor
Jan 18, 2021

Nelz_ 

 

Perhaps

Units/Min =[@[No. Units]]/([@[Arr vs Dep]]*1440)

Units/Hr =[@[Units Per Minute]]*60

 

In excel, time is measured in days. So, to convert a time to number of minutes you would multiply by 1440 mins/day. 

  • Nelz_'s avatar
    Nelz_
    Copper Contributor
    Jan 19, 2021

    JMB17 Thank you for that