MSSQL help using date function - to get peak range of ATIME and EndTime

[dragrid]

Hi anyone - appreciate any help

I would like to get * one column * with that min of the day instead of hr and min separately
So the first line for example 18:50 pm would be the 1130 min of the day
And if it was 6:50 am would be 410 min of a day
What is the best function I can use in my select statement to get this and be able to group by it ?

select datepart(yyyy,ATIME)as yr, datepart(mm,ATIME)as mth, datepart(dd,ATIME)as daday
,datepart(hh,ATIME)as hr,datepart(mi,ATIME)as strtmin
From table
Where (ATIME >= '2010-02-01 00:00:00') and (ATIME <= '2010-02-28 23:59:59')
and datename(weekday,ATIME) in ( 'Friday','Saturday','Sunday')
group by datepart(yyyy,ATIME),datepart(mm,ATIME),datepart(d d,ATIME),
datepart(hh,ATIME),datepart(mi,ATIME)
order by strtmin desc

yr mm dd hr mi
2010 2 13 18 50
2010 2 6 18 50
2010 2 26 14 50
2010 2 28 9 50
2010 2 14 20 49
2010 2 20 16 49
2010 2 12 1 49
2010 2 28 19 49
2010 2 5 1 49

My columns looks like this
ATIME EndTIME

2010-02-01 00:00:00.000 2010-02-01 00:02:30.000
2010-02-01 00:00:00.000 2010-02-01 00:00:26.000
2010-02-01 00:00:02.000 2010-02-01 00:55:53.000
2010-02-01 00:00:02.000 2010-02-01 00:16:35.000

Thanks in advance

[Delerna]

Don't know it there is a function (probably) but it is an easy math problem

SELECT datepart(hh,ATIME) * 60 + datepart(mi,ATIME) as MinuteOfTheDay
FROM........

[ck9663]

Are you talking about getting the elapsed time in minutes since midnight? Use DATEDIFF().

Happy Coding!!!

~~ CK