how to format timestamp out put into hours min and sec

[#1]

How do i format the out come of substracting two timestamps into minutes or seconds. for instance this statement out come is 1 min 04 sec. I want to displace the average time taken in minutes and seconds

=Interval(Num(Date#('04-08-2012 05:11:11', 'DD-MM-YYYY hh:mm:ss')) - Num(Date#('04-08-2012 05:12:15', 'DD-MM-YYYY hh:mm:ss')))

The out put is like - 0:01:04.

[sushil353]

Hi,

Try this:

=

date(avg(Interval(Num(Date#('04-08-2012 05:12:15', 'DD-MM-YYYY hh:mm:ss')) - Num(Date#

('04-08-2012 05:11:11', 'DD-MM-YYYY hh:mm:ss')))),'mm:ss')

HTH

Sushil

[Gysbert_Wassenaar · Accepted solution]

Try adding a mm:ss format string to the interval function:

=Interval(Date#('04-08-2012 05:11:11', 'DD-MM-YYYY hh:mm:ss') - Date#('04-08-2012 05:12:15', 'DD-MM-YYYY hh:mm:ss'), 'mm:ss' )

[#4]

try this

=Interval(Date#('04-08-2012 05:11:11', 'DD-MM-YYYY hh:mm:ss') - Date#('04-08-2012 05:12:15', 'DD-MM-YYYY hh:mm:ss'),'hh:mm:ss')