round seconds

[soniasweety]

Hi all ,

I have one column like duration 

that are in seconds  like

30210.00

916372.00

56483.00

like above I don't want to see .00  I want  output like

hh.mm  : =30210     is to be shown like this   8.39  

am using in my script already like this    Num([Duration],'#.#0') as "Task Duration",   I need along with this format

Thanks

Sony

[PrashantSangle]

try like

floor(fieldName)/3600

Regards

[soniasweety]

thanks Prashanth,

but I need the format also  like what I mentioned above.

how can include this into above?

is this correct?

floor( Num([Duration]/3600,'#.#0')) as "Task Duration"

[PrashantSangle · Accepted solution]

num(floor(dateField)/3600,'##.##')

Regards

[soniasweety]

thanks prashanth its working as expected