I need you to fix this query to show Total in Hours and Minutes. Then I also need a column to show Total*2 AS PERSONAL TIME.
What I am trying to do is calculate the time difference between Time_In and Time_Out and then show the difference as well another field called Personal TIme that divides the difference by a number. This is used to calculate vacation time our employees have earned. should be easy for a sql pro.
MY CURRENT QUERY IS:
select *, DateDiff(MI, Time_In, Time_Out) as Total
EXAMPLE RESULTS I NEED:
Time In Time Out Total Hours Personal Time
5:30:00 15:00 10.5 5.25
5:00:00 15:30 10.5 5.25
5:00:00 15:00 10 5