Time Conversion/Formula

[amerifax]

I am using Excel 2007. I am trying to do a few time calculations. I am using a time in and a time out (in a 12 hour format). I am also putting in a time to subtract in minutes. The calcuations I need to come up with are a difference between the time in and time out in an hours and minutes format. I also need to take that result and mulitply it by 60 to come up with the total minutes.

I know these are probably just a matter of formatting the cell but I have been working at it and can not seem to come up with the correct results. Any help would be greatly appreciated.

Bob Snow

 

[ianward]

This is what I use (although you must use 24hr clock format) and displays the total minutes:

((B2-A2)*24)*60

Where:
B2 = Time Out
A2 = Time In

Hope this helps - Ian

 

[amerifax]

Thanks for your help.

Bob