Date Difference Hours, Minutes

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
Thank you, exactly what I needed!

Mike H said:
Jim

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

Mike

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