create time calculation formula

J

Jcraig713

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!
 
B

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)
 
D

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
 
Top