Date Difference Hours, Minutes

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
 
J

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

years-months-days-hours 5
day of the week and date formula 2
Calculate time worked based on start / end times & working hours 3
Difference in Days, Hours, Minutes and Seconds 15
Calculating diff between date/ time only between certain hours 5
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
Pvtbl Grouping: Time Duration 3
Difference of time 3

Top