decimal date format to hour and minute

[#1]

hi,

Pivot table - expression

(interval(time(End, 'hh:mm') - time(Start, 'hh:mm'), 'hh:mm')*24)

i am using this is to find out the difference between dates and i am getting the values in decimal format. i want to convert this to hour and second format.

for example

one row Start has value  09/05/2014 05.01 AM and End has value 09/05/2014 01.21 AM. I am getting the out put 20.33 (Its a decimal value, i need it as 20.20)

Anybody please let me know.

Thanks

Ranjith Kumaran

[MK_QSL]

Try

interval(time(End, 'hh:mm') - time(Start, 'hh:mm'), 'hh:mm')

[MarcoWedel]

interval(End-Start, 'hh.mm')

[#4]

i want to use that in a column as sum(processqty)/ (interval(time(End, 'hh:mm') - time(Start, 'hh:mm'), 'hh:mm')*24).

need to convert that to hour and minute format before the division... can i use the same?

[MarcoWedel]

if you want to calculate your processquantity per hour, then

sum(processqty)/((End-Start)*24)

is sufficient.

sum(processqty)/(End-Start)

would give you a processquantity per day.

regards

Marco