SUM hours in sql server

• Question

• 

  

  0

  Sign in to vote

  Hello , please i tried to make a sum on hours and minute when i convertet to decimal i don't get same result 

  here the exemple in excel sheet 

  

  and here the function that i used in sql server 

  sum(cast(datepart(hour, [HOUR]) + (datepart(minute, [HOUR])) / 100.00 as decimal(5, 2)))

  any idea please how to fix this by function in sql server to get same result 23:38 

  thank you 

  
  

  • Edited by AsmaGh Thursday, November 26, 2020 7:04 PM
  • Moved by Dave PatrickMVP Thursday, November 26, 2020 7:07 PM looking for forum

  Thursday, November 26, 2020 7:04 PM