>>>>If I have a value of 72600, which represents the number of seconds elapsed since midnight, which also happens to be 08:10 pm, how do I convert that into a string that says simply 08:10 pm? Getting the hours is easy, it's the minutes I'm having a problem with. I think I'm going brain dead.
>>>
>>>See Message #482883.
>>
>>It's close. It should give me some ideas of how to get to what I want. Thanks.
>
>James,
>
>Try:
>

>TTOC(DATETIME(1900, 1, 1, 0, 0, 0) + 72600, 2)
>

>
>Cheers,
>
>Andrew


and the old fashioned way :~)

? AllTrim(STR(IIF(INT(Val(sys(2))/3600)> 12,INT(Val(sys(2))/3600)-12,INT(Val(sys(2))/3600))))+":"+ALLTRIM(STR(INT(60*(Val(sys(2))/3600 % 1))/10))+AllTrim(STR(INT((Val(sys(2))/3600) % 6)/100)+IIF(INT(Val(sys(2))/3600)> 12," pm"," am"))