Parsing out Time and calculating it.

[#1]

Hello, I was hoping someone could help.

I want to write an expression that calculates the length of time it took to work on a ticket, based on this date format.

=count (ActulStrtTstmp) - (ActulEndTstmp)

How would I display this at this

0 Day 1 hr 15 min (for example?

Start Time 2014-01-27 13:59:31

End Time 2014-01-27 15:10:37

Thanks in Advance

[sunny_talwar · Accepted solution]

May be this:

=Interval([Start Time] - [End Time], 'D hh:mm')

or

=Interval([Start Time] - [End Time], 'D') & ' Day ' & Interval([Start Time] - [End Time], 'h') & ' hr' & Interval([Start Time] - [End Time], 'mm') & ' min'

[#3]

Awesome, they bother worked great.

Thanks a lot.