Demo<>Minute Into Days, Hour, Minute in SQL Server, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

select @@version as 'sql server version'

Declare @theMinutes Varchar(10)
Set @theMinutes = '19:25'

declare @totMintute int
Select    
  @totMintute = (Cast(
  Cast(left(@theMinutes,charindex(':',@theMinutes)-1) as Int) * 60
  + Cast(substring(@theMinutes,charindex(',',@theMinutes)+4,len(@theMinutes)) as Int)  
as Int ) * 60) / 60

--For 12 hour 1 days
Select @totMintute / 720 as NoDays  -- 1440 minutes per day 
       , (@totMintute % 720) / 60 as NoHours -- modulo 1440 
       , (@totMintute % 60) as NoMinutes -- modulo 60
       
--For 24 hour 1 days
Select @totMintute / 1440 as NoDays  -- 1440 minutes per day 
       , (@totMintute % 1440) / 60 as NoHours -- modulo 1440 
       , (@totMintute % 60) as NoMinutes -- modulo 60
       
--Creating and inserting values in table
Create table #Temp (MinValue Varchar(8))
insert into #Temp Values ('19:25'), ('21:57'), ('00:02')

--Query from table for 12 hour format
Select TotMinute / 720 as NoDays  -- 720 minutes per day 
       , (TotMinute % 720) / 60 as NoHours -- modulo 720 
       , (TotMinute % 60) as NoMinutes -- modulo 60
from(
select 
(Cast(
  Cast(left(MinValue,charindex(':',MinValue)-1) as Int) * 60
  + Cast(substring(MinValue,charindex(',',MinValue)+4,len(MinValue)) as Int)
as Int ) * 60) / 60  as TotMinute
from #Temp
)a

--Query from table for 24 hour format
Select TotMinute / 1440 as NoDays  -- 720 minutes per day 
       , (TotMinute % 1440) / 60 as NoHours -- modulo 720 
       , (TotMinute % 60) as NoMinutes -- modulo 60
from(
select 
(Cast(
  Cast(left(MinValue,charindex(':',MinValue)-1) as Int) * 60
  + Cast(substring(MinValue,charindex(',',MinValue)+4,len(MinValue)) as Int)
as Int ) * 60) / 60  as TotMinute
from #Temp
)a

View schema
Execution time: 0,02 sec, rows selected: 11, rows affected: 3, absolute service time: 0,22 sec, absolute service time: 0,21 sec