Hello!
I have read a lot of discussions about this topic, with a number of advanced solutions, and I have tried them all out, but of one or another reason, I can not find anything that works.
Situation: I need to calculate elapsed time into a number format, and I also need to handle the situation with passing midnight.
Example: Start time: 23:30 End time: 01:00 (The next day), which is 1 hour and 30 minutes, to be displayed as this: 1.5
I have the following:
[Start time] - Date/Time format - short time - does not include the date
[End time] - Date/Time format - short time - does not include the date
In the query I have a simple code that handles passing midnight, but not the convertion to number format.
Medgått tid: Format([Tid fra]-1-[Tid til];"Kort klokkeslett"), as in english would be:
Elapsed time: Format([Start time]-1-[End time];"Short time")
This code gives me: (From 23:30 to 01:00) 1:30 as result (as is also correct) - but I want the result to be 1.5
Besides all the other advanced solutions I have found, I have also tried to change "Short time" (in the code) with; "Number", but this will not to the trick.
Hope anyone out there have a real solution.
Børge
Norway