# Date/Timestamp difference in HH:MM

1. ## Date/Timestamp difference in HH:MM

Good day,

I'm trying to calculate the difference between two date/timestamps in HH:MM, and am having no luck. Perhaps it's my utter lack of even basic mathematical abilities or not understanding the code samples I've found on various sites, but everything I do is just inaccurate.

For example
Start Date = 3/10/2014 8:30 AM
End Date = 3/12/2014 9:45 AM
Should result in 49:15

Sometimes the dates will be on the same day, sometimes not.
The start date could be in the last day or two of December, so the year matters, too.

Thank you for any help.

2. ## Re: Date/Timestamp difference in HH:MM

I get 48h 45mins?

3. ## Re: Date/Timestamp difference in HH:MM

I get 2 days 1hr 15mins

4. ## Re: Date/Timestamp difference in HH:MM

Sorry, i'd put 9:15. Your formula will be end date-start date with a custom format of [hh]:mm

5. ## Re: Date/Timestamp difference in HH:MM

Try this:
``Please Login or Register  to view this content.``
Can easily be rewritten to a UDF.

All best,
Johan

6. ## Re: Date/Timestamp difference in HH:MM

Johan - thank you...that is exactly what I was looking for... will test out a few more scenarios but it looks great.

Thank you...
And to nathansav and Special-K.... I really appreciate your time as well!

7. ## Re: Date/Timestamp difference in HH:MM

You're welcome Thanks for your kind feedback and the positive rep added.

Best,
Johan

There are currently 1 users browsing this thread. (0 members and 1 guests)