Convert Timevalue into Seconds

[vqthomf]

I am taking a time value from a listview column and I am trying to convert it
into seconds, I have tried timevalue to give me the time and then /60 but
this is not working can someone point me in the right direction please.
Thanks

 

[Karl E. Peterson]

I am taking a time value from a listview column and I am trying to convert it
into seconds, I have tried timevalue to give me the time and then /60 but
this is not working can someone point me in the right direction please.

Okay, well, first off, that just doesn't make sense. Into seconds? Seconds of
what, or since when?

Are you talking about using the TimeValue() function? For example, this is from my
Immediate window:

?timevalue(now)
11:18:06 AM

In COM, date/time values are stored as double-precision numbers, with the date in
the whole portion and the time in the fractional portion. The time corresponds to a
fraction of a day. So, if you want to know, say, the number of seconds since
midnight, you need to *multiply* the timevalue by the number of seconds in a day.
Make sense?