Time Difference

[#1]

Hi All,

I have two Fields start Time and End Time.i need to find the the difference between the Time in HH:MM:SS format. But the fields are not in the Time format(ie. if it is 10:16:25,then the field contains the value as 101625). How can I achieve the same. pls suggest.

Thanks in Advance.

[MK_QSL · Accepted solution]

=Interval(Time(Time#([End Time],'hhmmss'),'hh:mm:ss') - Time(Time#([Start Time],'hhmmss'),'hh:mm:ss'),'hh:mm:ss')

[PrashantSangle]

Hi,

Try like this,

In script format it like

date(date#(startTime,'hhmmss'),'hh:mm:ss') as new_StartTime,

date(date#(endTime,'hhmmss'),'hh:mm:ss') as new_EndTime

Then use formula

like Interval(new_EndTime-newStartTime,'hh:mm:ss')

Or If you dont want to do in script level

then

=Interval(date(date#([End Time],'hhmmss'),'hh:mm:ss') - date(date#([Start Time],'hhmmss'),'hh:mm:ss'),'hh:mm:ss')

Regards

[MarcoWedel]

=Interval(Time#([End Time],'hhmmss') - Time#([Start Time],'hhmmss'),'hh:mm:ss')