Skip to Content
0
Former Member
Nov 15, 2016 at 06:52 PM

Webi: How to calculate time differencein Hrs between 2 dates

689 Views

Hi Experts,

Is there a more effective formula other than th eone below to calculate difference in dates(hrs) and (min)

=((((ToNumber(Substr(FormatDate([Entry Timestamp] ; "HH:mm:ss") ; 1 ;2 ) ) * 60 *60+ToNumber(Substr(FormatDate([Exit Timestamp] ; "HH:mm:ss") ; 4 ;2) ) * 60 +ToNumber(Substr(FormatDate([Entry Timestamp]; "HH:mm:ss") ; 7 ;2 ) )) - (ToNumber(Substr(FormatDate([Exit Timestamp] ; "HH:mm:ss") ; 1 ;2 ) ) * 60 *60+ToNumber(Substr(FormatDate([Exit Timestamp] ; "HH:mm:ss") ; 4 ;2) ) * 60 +ToNumber(Substr(FormatDate([Exit Timestamp] ; "HH:mm:ss") ; 7 ;2 ) ) ))) / 60 + (DaysBetween([Exit Timestamp] ; [Entry Timestamp]) * 24 * 60) ) / 60