Calculate hours from start_Time and End Time columns (12 hours time)
I have two columns in SQL table 'Start-Time' and "End-Time" in 12 hours time. I want to calculate the Hours field in new column based on difference between start tie and end time. Please guide me.
Regards,
Dinesh
You could do it basically like this (untested, but I think it will work):
SELECT
Start_Time,
Finish_Time,
DATEADD(minute,
DATEDIFF(minute,start_time,finish_time),
'00:00:00'
) as [Hours]
FROM some_table;
