I have a table which has 2 columns Start Time and End Time both columns are formatted as Date/Time Short Time. i.e
Start Time End Time Duration
00:00 00:00 00:00
I would like to use the columns to calculate the Duration column however I am not having much success. I am trying to use a SQL Query which looks like the below:
SELECT DATEDIFF([StartTime],[EndTime]) as Duration FROM [DailyTaskLog]
I am sure that I have use something simular to this and it has work however I am having a complete mind blank and am not sure what I am doing wrong.