Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to convert HH:MM to minutes in sql server.
Posted
Comments
Sandeep Mewara 16-May-12 2:14am    
Why repost? Please avoid it from next time.

1 solution

Try this:

SQL
SUM(DATEPART(hh,TACK_CLOCKINGREGISTRATION.DURATION) * 60 +
DATEPART(mi,TACK_CLOCKINGREGISTRATION.DURATION) +
DATEPART(ss,TACK_CLOCKINGREGISTRATION.DURATION) * 0.017)
 
Share this answer
 
Comments
rakesh@bbspl.com 16-May-12 1:45am    
thanks lot....
Prasad_Kulkarni 16-May-12 1:46am    
Glad it helps!
You're welcome..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900