P
Paul Overway
Assuming you are using a complete date and time in the field (which you
should be):
[ElapsedTime] = ([EndTime] - [StartTime]) * 24
The result will be in the form 25.0166666666628 . If you REALLY want the
format to be 25 hours 1 minute, you'll need to write a function.
should be):
[ElapsedTime] = ([EndTime] - [StartTime]) * 24
The result will be in the form 25.0166666666628 . If you REALLY want the
format to be 25 hours 1 minute, you'll need to write a function.