Calculate Total Time

[richrich05]

I'm trying to to calculate two datetime fields into total minutes and hours. Anyone know a way to do this function?

Something like (Starttime)(Endtime) = Totaltime

 

[gmmastros]

Are you trying to get the difference in time? Like this...

declare @Start DateTime
Declare @End DateTime

Set @Start = '6/10/2007 8:15 AM'
Set @End = '6/10/2007 10:55 AM'

Select @End - @Start

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Crowley16]

if you use the datediff function, you can tell it to return the result in whatever time units you want...

--------------------
Procrastinate Now!

 

[monksnake]

Total minutes and hours from 1900-01-01??


<.

 

[richrich05]

actually i do have some dates in my table as 1/1/1900 i figured i would use a else statment and show the column as a blank row.

 

[monksnake]

OK!!!!.... I'm lost.

<.

 

[richrich05]

Well I'm trying to convert a date field called endtime from '6/10/2007 8:15 AM' and the starttime field into some kind of total of hours and minutes.