Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create time calculation formula
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create time calculation formula
=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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
create time calculation formula
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
create time calculation formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formula | Excel Discussion (Misc queries) | |||
Formula for a time card | Excel Worksheet Functions | |||
Time Calculation Formula! | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions |