Date/ Time Formula in Excel

[Mike]

I need help creating a formula that calculates the number of minutes and
hours (and days if easier to formulate) between cells that exceed 24 hours.
Here is an example of what I am trying to calculate:

Cell B2 Cell K2
4/8/2009 07:15 4/10/2009 09:15

Thank you for any help you can provide.

Mike

 

[Mike H]

Mike

=K2-B2

Format the dormula cell with the custom format of [hh]:mm

the [] around the hours stop it rolling over to 1 in excess of 24

Mike

 

[Mike]

Thanks Mike, the [ ] was the missing piece.

Mike

=K2-B2

Format the dormula cell with the custom format of [hh]:mm

the [] around the hours stop it rolling over to 1 in excess of 24

Mike

I need help creating a formula that calculates the number of minutes and
hours (and days if easier to formulate) between cells that exceed 24 hours.
Here is an example of what I am trying to calculate:

Cell B2 Cell K2
4/8/2009 07:15 4/10/2009 09:15

Thank you for any help you can provide.

Mike