create time calculation formula

[Guest]

I would like to create a formula to enter a start time (ex. 9:12am) and an
end time (ex. 4:04pm).
The formula would need to output the number of minutes within that time
frame. I have searched the help area and cannot find examples of this
process. Can someone help? Thanks!

 

[Bob Phillips]

=INT((end_time-start_time))*24*60

and format as General

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Don Guillett]

try this for hours
=(J11-J10)*24
and this for mintues
=(J11-J10)*24*60

 

[Dav]

subtract the start from the finish and format as [mm]
or
or subtract the start from the finish multiply by 24 x 60 and display
as a number

Regards

Dav