seperate time alone from Time Stamp value

[RajGru]

Hi,

Time stamp has both time & date .Is it possible to seperate time alone from the time stamp value?. 

[RajGru]

Hi,

I found that. I used Format Date/time String to get the Time alone.

Is there any function to convert from that Time- string(1:01:01 AM), to seconds.

Regards,

Raja 

Message Edited by Rajaa on 10-17-2008 05:31 AM

[PhillipBrooks · Accepted solution]

If you want to know the number of seconds since the start of the day, you can use Seconds to Date/Time and then unbundle the hours, minutes and seconds, then calculate the total seconds.

 

If you want to perform some calculations between two time stamps, you can use the math functions ( +, - ) directly; see Jim Kring's blog post located here...

Message Edited by Phillip Brooks on 10-17-2008 07:05 AM