Date Difference Hours, Minutes
 

I've searched and can't find a formula for this scenario. I need to
calculate the difference between two dates and need the results displayed as
listed next to Duration. If the calculation results in more than 24 hours,
I'd like it to display something like 25H 13M. Is this possible?

EventStart 8/11/09 15:40
EventEnd 8/11/09 23:56
Duration 8H 16M

Thanks!
Jim

Date Difference Hours, Minutes
 

Jim

Simply subtract earlier date from later one and format as [h]"H "mm"M"

Mike

"Jim" wrote:

I've searched and can't find a formula for this scenario. I need to
calculate the difference between two dates and need the results displayed as
listed next to Duration. If the calculation results in more than 24 hours,
I'd like it to display something like 25H 13M. Is this possible?

EventStart 8/11/09 15:40
EventEnd 8/11/09 23:56
Duration 8H 16M

Thanks!
Jim

Date Difference Hours, Minutes
 

Thank you, exactly what I needed!

"Mike H" wrote:

Jim

Simply subtract earlier date from later one and format as [h]"H "mm"M"

Mike

"Jim" wrote:

I've searched and can't find a formula for this scenario. I need to
calculate the difference between two dates and need the results displayed as
listed next to Duration. If the calculation results in more than 24 hours,
I'd like it to display something like 25H 13M. Is this possible?

EventStart 8/11/09 15:40
EventEnd 8/11/09 23:56
Duration 8H 16M

Thanks!
Jim