Date conversions in a report

[bill22]

I am building a report to calculate the total number of hours a vehicle has worked during a period of 10 days. The data in the databes (external) returns a field L_DURATION that gives the value 805.018,00 which represents about 10 days of work.

How can i convert this to hours and minutes

 

[Sum Guy]

Try entering in the text box of the report:

=([L_DURATION] / 60)

That will give you the hours with a decimal value for the fraction of hours. In the format property you can limit the number of decimal places. For example if you enter 0.00 it will limit it to 2 decimal places.
Hopefully someone else will know how to get the minutes for you.