Hi,
I'm new to Access (like thousands of others here :banghead and am having an issue with Access not liking to display elapsed time over 24 hours correctly.
My original expression for this field was [Outage End] - [Outage Start]. I kept the result type as Date/Time but used a custom Format: dd:hh:nn.
When I was going over some of the latest data entered in the database today, I noticed that any calculation that had a result of over 24 hours was wrong. I've tried a myriad of supposed ways found on the internet to fix this, but either the instructions on how to use the code are vague and unclear or it just doesn't work.
A few examples:
This works-
Outage Start- 05/08/2014 18:07
Outage End- 05/08/2014 18:30
Elapsed- 00:23
This does not:
Outage Start- 05/08/2014 01:08
Outage End- 05/12/2014 15:07
Elapsed- 13:59 (should read 04:13:59)
Any detailed help on how to make this work right would be very very much appreciated.
I'm new to Access (like thousands of others here :banghead and am having an issue with Access not liking to display elapsed time over 24 hours correctly.
My original expression for this field was [Outage End] - [Outage Start]. I kept the result type as Date/Time but used a custom Format: dd:hh:nn.
When I was going over some of the latest data entered in the database today, I noticed that any calculation that had a result of over 24 hours was wrong. I've tried a myriad of supposed ways found on the internet to fix this, but either the instructions on how to use the code are vague and unclear or it just doesn't work.
A few examples:
This works-
Outage Start- 05/08/2014 18:07
Outage End- 05/08/2014 18:30
Elapsed- 00:23
This does not:
Outage Start- 05/08/2014 01:08
Outage End- 05/12/2014 15:07
Elapsed- 13:59 (should read 04:13:59)
Any detailed help on how to make this work right would be very very much appreciated.