Converting time format to seconds 1

[merlynsdad]

I'm subtracting 8:57:33 AM from 6:33:18 PM in VBA and getting 0.399826388888889 in a field which is type double. I have to convert this to seconds. I've seen the conversions from seconds to time format, but I'm going the other way and don't know what the 0.39+ actually represents time wise, if anything. Any help would be appreciated.

If the square peg won't fit in the round hole, sand off the corners.

 

[MajP]

You can use the datediff function and specify an interval.

The value is fraction of a day so
.398 * (24 hours in a day) * (60 minutes in hour) * (60 seconds)
or 86400.