>>>>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
Not bad! That gives me exactly what I'm looking for. Thanks!