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!

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

and format as General

--
HTH

Bob Phillips

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

"Jcraig713" wrote in message
...
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!

try this for hours
=(J11-J10)*24
and this for mintues
=(J11-J10)*24*60
--
Don Guillett
SalesAid Software

"Jcraig713" wrote in message
...
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!

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=556427