I need to calculate time greater than 24 hours for some jobs. The table data is in date/time format but I can not get access to calculate job run time over that 24 hour hump.
The table data looks like this
Event Start time End time
job 1 7:24:09 AM 3:49:48 PM
I then run a query that gives me
Event Start time End time Run Time
job 1 7:24:09 AM 3:49:48 PM 08:25 hh:mm
Note the 8 hours 25 min run time
But in actual fact it should be
Event Start time End time Run Time
job 1 7:24:09 AM 3:49:48 PM 32:25 hh:mm
Note the 32 hours 25 min run time.
Here is my SQL
SELECT [Activity Log].Event, [Activity Log].[Start time],
[Activity Log].[End time], Format([start time]-1-[end time],"Short Time"
AS [Run Time]
FROM [Activity Log]
WHERE ((([Activity Log].Event)=" job 1");
What am I missing, I have tried other answers to simular posts, but
have not had any luck.
Thanks
Kirk
The table data looks like this
Event Start time End time
job 1 7:24:09 AM 3:49:48 PM
I then run a query that gives me
Event Start time End time Run Time
job 1 7:24:09 AM 3:49:48 PM 08:25 hh:mm
Note the 8 hours 25 min run time
But in actual fact it should be
Event Start time End time Run Time
job 1 7:24:09 AM 3:49:48 PM 32:25 hh:mm
Note the 32 hours 25 min run time.
Here is my SQL
SELECT [Activity Log].Event, [Activity Log].[Start time],
[Activity Log].[End time], Format([start time]-1-[end time],"Short Time"
AS [Run Time]
FROM [Activity Log]
WHERE ((([Activity Log].Event)=" job 1");
What am I missing, I have tried other answers to simular posts, but
have not had any luck.
Thanks
Kirk