I currently have 4 colums that I need to manipulate to give me an 'elapsed time' :
Start Date - This is in the usual date format of DD/MM/YY
Start Time - This is in decimal form, rather than hours and minutes. This will therefore show, for example, 9:25 (9 hours and a quarter) for 9:15 (quarter past 9). I have an Access query which transforms this into a hexidecimal (hours and minutes) form (see below).
Code:
SELECT DaisyMSR.[Start Time],
Int([Start Time]) AS Expr2,
[Start Time]-[Expr2] AS Expr3,
60*[Expr3] AS Expr4,
Round([Expr4],0) AS Expr5,
[Expr2] & ":" & [Expr5] AS Expr6
FROM DaisyMSR;
Fix Date - This is in the usual date format of DD/MM/YY
Fix Time - Same as the Start Time, this is in decimal and requires a query to convert it.
Would I would to do, is run a query which will show me the elapsed time. I'm assuming this will have to be a combination of the two code's for 'Start Time' and 'Finish Time' but I'm no expert in programming or Access so I'm not getting very far!
I hope it's possible!
Thanks,