Time calculation

General
1

I have an Integer which contains elapsed time, i.e. 104. In Excel I use this formula:

=ABS(104/24/60)

and format the cell as Time which gives me 01:44:00 (One hour and fortyfour minutes), which is correct.

How can I get this timevalue ‘01:44:00’ in Xojo?

2

Alexander,
This will do i think:

dim t as Double = 104*60 dim d1 as new date(1900,1,1,0,0,0) d1.TotalSeconds = d1.TotalSeconds + t MsgBox right(d1.SQLDateTime,8)

3

Hi Andre,

thanks. I’ll give it a try.

Edit: this is exactly what I meant. Thanks again.