Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding Time 1
- Thread starter JaeBrett
- Start date
nigelrivett
IS-IT--Management
Are these datetimes?
if so you should be able to just sum the fields.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
if so you should be able to just sum the fields.
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
- Thread starter
- #3
-
1
- #4
DateTime types are stored as Doubles, where the Integer part is the days since Dec 30th 1899 and the fractional part is the fraction of a day since midnight.
[tt]myTime - Int(myTime)[/tt]
gives the fractional part of each value. Add these to get a total. Then
[tt]Int(myTotal) [/tt]
gives the days in the total and
[tt]Format(myTotal,"hh:mm:ss") [/tt]
will give the hours, minutes and seconds in your total.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
[tt]myTime - Int(myTime)[/tt]
gives the fractional part of each value. Add these to get a total. Then
[tt]Int(myTotal) [/tt]
gives the days in the total and
[tt]Format(myTotal,"hh:mm:ss") [/tt]
will give the hours, minutes and seconds in your total.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
- Status
