Time format

[#1]

I want certain format to get difference in two times in total hours: minutes and seconds

Like in attached picture of excel format

[agni_gold]

What you hava , Timestamp or only time ?

[#3]

time!

look at the picture attached

its 37hours:30minutes:55seconds

[er_mohit · Accepted solution]

you must know the format of time field

then use interval function like this

interval(timefield1- timefield2,'hh:mm:ss')

here for both timefield format should be same  if don't then before interval function use timestamp# function

[#5]

Try  Date(Field,’hh:mm:ss’)

[#6]

offcourse that would not work!

date is not required

[#7]

Try this hope it will help

=interval(time1-time2,'hh:mm:ss')

[#8]

Try this

=Interval(Timestamp#('26-11-2013 02:15 PM','DD-MM-YYYY hh:mm TT')-Timestamp#('24-11-2013 01:30:30 PM','DD-MM-YYYY hh:mm:ss TT'),'hh:mm:ss')

Here first time field need to be greater the second time field other wise u will get the minus value.