If the figures in your table are actually minutes (eg, 0.50 means half a

minute or 30 seconds) then your total is minutes and a decimal fraction of a

minute. So elapsed time would be:

Minutes = Int(Total)

Seconds = (Total - Minutes) * 60

If the minutes could be greater than 60 then you need to break minutes into

hours and minutes.

Hours = Minutes \ 60

Minutes = Minutes - (Hours * 60)

Quote:

> Hi all

> Please anybody can help to solve the probelm to derive the time from a

> table

> having the column 'minitus'. In this column I am storing the minitus as

> follows

> .30

> .40

> .50

> .40

> .30

> I have to find out the total minitus taken for a period

> Select sum(minitus) into :ldec_minitus

> from attendance

> where datefrom >= #01-01-2009# and dateto <= #12-01-2009#

> ldec_minitus = 20.50 . But it is not actual time . I need to convert into

> hrs and minitus by using 60. So please anybody can help me to derive the

> hrs

> and minitus from a total figures by using 60.

> With thanks and Regards

> Pol