Concluído

198088 SQL Query

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

from TCS_EMPLOYEE_LOG

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

Habilidades: Vale Tudo, SQL

Veja mais: n query, SQL Query, fix query, sql select select, sql select, query query, sql query field, time difference, fix sql, need sql query, sql query sql query, sql show results, sql number, SQL Fix, difference hours, sql select calculate, sql field

Acerca do Empregador:
( 59 comentários ) Belleville, United States

ID do Projeto: #1944309

Concedido a:

gustavofrigo

got the query, escrow to proceed

$8 USD em 0 dias
(0 Comentários)
0.0