=ROUND((((7500/180)*1.25)*(46/60+30)),2) 2,421.88 in excel
But I am not getting this result in SQL, Below is the sql statement
Declare @Time int
Declare @LoginTime datetime
Declare @LogoutTime datetime
SET @LoginTime = '2017-07-03 08:00:00'
Set @LogoutTime = '2017-07-05 06:30:00'
Set @Time = DATEDIFF(Minute,@LoginTime,@LogoutTime)
--SELECT 46.30 * (7500/180) * 1.25 --(46.30 * 1.0 / 60)* (7500/180) * 1.25
SELECT ROUND(CAST(@Time/60 AS INT)* ROUND((CAST(7500 AS FLOAT) / CAST(180 AS FLOAT)* 1.25),2) + RIGHT('0' + CAST( @Time%60 AS INT), 2),2)