Convert Date Value

C

ChuckW

Hi,

I have a field with time values of 00:01:45 which
represents 1 minute, 45 seconds. I want to convert this
to seconds and have this value by 90. Is there a
functions that would allow this?

Thanks,

Chuck
 
D

Douglas J. Steele

If it's a Date field, then the time is stored as a fraction of a day (i.e.:
06:00:00 is .25, 12:00:00 is .5, 18:00:00 is .75 and so on). That means
00:01:45 will be stored as .00121527777777778.

Since there are 86400 seconds in a day (24 * 60 * 60), simply multiply the
time by that number to convert it to seconds.

I don't know where the 90 enters into it, though. 00:01:45 would be 105
seconds.
 
D

Duane Hookom

Mulitple your time x 86400 which is the number of seconds in a day. I don't
understand your statement "and have this value by 90".
 
O

Ofer

try
datediff("s","00:00:00","00:01:45")

Duane Hookom said:
Mulitple your time x 86400 which is the number of seconds in a day. I don't
understand your statement "and have this value by 90".
Click to expand...
 
Top