Gordon Hughes
asked on
Show differences in time
I have a report which has in the database fields
RequestDate
RequestTime
Investcompdate
investcomptime
From a report standpoint, I have created the follow:
Requested Date Time = CDateTime (Date({WO.REQUESTDATE}) & " " & Time({WO.REQUESTTIME}))
Investigated = CDateTime (Date({WO.INVESTCOMPDATE}) & " " & Time({WO.INVESTCOMPTIME}))
These two formula work fine
What I am looking for is a formula which will sow me the time elaped between the RequestDate/RequestTime and the Investcompdate/Investcompt ime
as a decimal figure ie 15 mind would be 0.25
Gordon
RequestDate
RequestTime
Investcompdate
investcomptime
From a report standpoint, I have created the follow:
Requested Date Time = CDateTime (Date({WO.REQUESTDATE}) & " " & Time({WO.REQUESTTIME}))
Investigated = CDateTime (Date({WO.INVESTCOMPDATE})
These two formula work fine
What I am looking for is a formula which will sow me the time elaped between the RequestDate/RequestTime and the Investcompdate/Investcompt
as a decimal figure ie 15 mind would be 0.25
Gordon
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER