Date/ Time Formula in Excel
 

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

Date/ Time Formula in Excel
 

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" wrote:

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

Date/ Time Formula in Excel
 

Thanks Mike, the [ ] was the missing piece.

"Mike H" wrote:

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" wrote:

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