on 11-16-2015 5:42 PM
Hi,
First you needs to convert the date & time in seconds and then subtract.
Var Diff in seconds=DaysBetween([Incident Reported Date Time] ;[Incident Last Resolved Date Time]) * 86400
+
(
ToNumber(FormatDate([Incident Last Resolved Date Time] ;"HH")) * 3600 +
ToNumber(Left(FormatDate([Incident Last Resolved Date Time] ;"mm:ss") ;2)) * 60 +
ToNumber(FormatDate([Incident Last Resolved Date Time] ;"ss"))
)
-
(
ToNumber(FormatDate([Incident Reported Date Time] ;"HH")) * 3600 +
ToNumber(Left(FormatDate([Incident Reported Date Time];"mm:ss") ;2)) * 60 +
ToNumber(FormatDate([Incident Reported Date Time] ;"ss"))
Later use this formula to convert seconds in the day.
=FormatNumber(Floor([Var Diff in seconds]/86400);"00") + "Days" +"."
FormatNumber(Floor(Mod([Var Diff in seconds ;86400)/3600);"00")
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.