How to get 0.5

[matthewnsarah07]

Two stored fields and one calculated unbound text box.

When I find the difference between working times like this:

([FinishTime] - [StartTime]) *24 , I should get a decimalised answer but where the answer is say 1.5hrs it only displays 1 in the unbound box

How can I get it to acknowledge partial hours

Thanks

 

[DJkarl]

Your calculation is probably converting to a long integer type (which doesn't have decimal places).

Try

Cdbl(([FinishTime] - [StartTime]) *24)

 

[matthewnsarah07]

Excellent. Thanks for that