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 need.

 

Also I'm currently using '1904 date system'

 

 

 

 

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. 

2 Replies

  • 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.