MAS90 Report Issue wtih CR 8.5 Date and Time fields

[webshel29]

I am trying to calculate the total time between four fields (Start Time, Start Date, End Time, End Date). The fields are strings and I cant seem to get the calculation formula correct. The start time and end time are converted and rounded up already..ex (07:30 is 7.5). The hours will be totals up and dates could vary so that has to be counted for as well. Any help would be appreciated.

 

[Halfcan]

Combine the date and time fields together to make 1 formula

ex:
formula 1:
DateTime({@startdate}, {@StartTime})

and in another formula:
formula 2:
DateTime({@Enddate}, {@EndTime})

Then subtract.

hope that helps.
Andy