Format time in decimal format

1

I have three columns in float8 format. This columns contain time, in decimal minutes (ex. 32911).

I need this times, in three format : ddd:hh:mm, total of hours and finally total of minutes.

To get the first format I need to apply this operations on the column :

NbDays = cint(32911 / 1440) = 22
Hours = cint(mod(32911, 1440) / 60) = 20
Minutes = mod(32911, 60) = 31

So : 22 * 24 = 528 hours or 32911 minutes or 22 days, 20 hours and 31 minutes.

What is the best way to do this things for this 3 columns ?

Jerome

2

You can use the div() and rem() functions:

NbDays = div([Value], 1440)

And

Hours = div([Value] - [NbDays] * 1440, 60)
Minutes = rem([Value], 60)

div-rem.morph (2.2 KB)