View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default 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