Date/ Time Formula in Excel

  • Thread starter Thread starter Mike
  • Start date Start date
M

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

=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
 
Thanks Mike, the [ ] was the missing piece.

Mike H said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top