Formula that shows units per minute '1904 date system'

[Nelz_]

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'

[#2 · Accepted solution]

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

[#3]

@JMB17 Thank you for that