计算总小时和分钟(HH.MM) [英] Calculating Total Hour and Minutes (HH.MM)
本文介绍了计算总小时和分钟(HH.MM)的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我有一张时间表,有两列时间(十进制)和分钟(int)
i需要找到小时和分钟的数据总和(HH:MM)
我写了查询
(转换( int ,(SUM(小时))
+(SUM(分钟)/ 60 )
+(SUM(分钟)%60 / 60 )))))+ ' 。' +
(转换( varchar ( 20 ),(SUM(分钟)% 60 )% 60 )))
来自 时间
但问题是当m的值是n个单位时在类似(0,1,2,...,9)中,输出就像例如
hrs = 5
mins = 7
然后输出是5.7
但是输出应该是5.07
你能帮帮我吗
谢谢
解决方案
SELECT CAST(@ Minute1 / 60 AS VARCHAR ( 5 ) )+ ' HH' + ' < span class =code-string>。' + RIGHT (' 0' + CAST(@ Minute1%60 AS VARCHAR ( 2 )), 2 )+ ' MM' AS ' WorkingTime'
声明 @ Minute Int = 560
SELECT CAST(@ Minute / 60 AS Varchar ( 20 ))+ ' HH' + ' 。' + RIGHT (' 0' + CAST(@ Minute%60 AS VARCHAR ( 20 )), 2 )+ ' MM' < span class =code-keyword> AS ' WorkingTime'
Hi
I have a table in time with two Columns hours (decimal) and minutes (int)
i need to find the sum of the data in hours and minutes (HH:MM)
I have written the query
(Convert (int, (SUM (hours )
+ ( SUM (minutes ) / 60 )
+ ( SUM (minutes ) % 60/ 60))))) +'.'+
(Convert (varchar (20), ( SUM (minutes ) % 60 ) % 60)))
From time
But the problem is when the value is n single digit in min like(0,1,2,...,9) then the output comes like eg
hrs=5
mins=7
Then the output is 5.7
But the output should come 5.07
Can you please help me out with it
Thank you
解决方案
SELECT CAST( @Minute1/60 AS VARCHAR(5))+ ' HH' + '.'+ RIGHT('0' + CAST( @Minute1%60 AS VARCHAR(2)), 2)+' MM' AS 'WorkingTime'
Declare @Minute Int = 560 SELECT CAST( @Minute/60 AS Varchar(20))+ ' HH' + '.'+ RIGHT('0' + CAST( @Minute%60 AS VARCHAR(20)), 2)+' MM' AS 'WorkingTime'
这篇关于计算总小时和分钟(HH.MM)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文