It's an extended question to this post. My question is a bit different, so I started a new thread.
It also may be more a math question than an Access one, but since I don't know the correct terminology, Google couldn't help.
I have a text box that shows a calculated elapsed time between two given date/time values.
example : 2 18:30:27 (2 days, 18 hours, 30 min & 27 sec)
How can I show this value as a 10 base number?
Some examples:
1 1:30:00 --> 25.5
0 1:15:00 --> 1.25
Thanks for any kind of advice
It also may be more a math question than an Access one, but since I don't know the correct terminology, Google couldn't help.
I have a text box that shows a calculated elapsed time between two given date/time values.
example : 2 18:30:27 (2 days, 18 hours, 30 min & 27 sec)
How can I show this value as a 10 base number?
Some examples:
1 1:30:00 --> 25.5
0 1:15:00 --> 1.25
Thanks for any kind of advice
Last edited: