Need help with calculation please

[Gabriel984]

I have 5 fields "start"(short Time) "End"(short time) "worked"=Format([Start]-1-[End],"Short Time") "rate"(currency) and "Total", all Im trying to do is calculate the total of "worked" multiplied by "rate" to give me the "total" Yes I know an Idiots question..but been working on this for hours and Im still unable to get anywhere, could some please point me in the direct, many thanks

[weekend00]

Somebody say you should not keep calculated field in the table. So, actually you need only 3 fields.

And, even if you really need to keep worked in you table, it should be a number, not a time nor a text.

Please remember [Start]-1-[End] is to calculate worked days, you need to set the rate by day. but you use short time for begin and end, I guess you want to calulate work hours. Please use ([start] - [end]) * 24 to calculate hours, and you need to round it to hour or quarter according your rule.

[Gabriel984]

Many, many thanx for your quick response... will give that a try, once again thankyou for your time

[Gabriel984]

I have followed your instructions and I am now able to get the results I was trying for, and I thank you for your help, however, when using a 24 hour system I get some negative numbers..ie: "start:13.00 end19.00 hours -6 start 20.00 end 08.00 hours 12
If I may ask for your kind help once more, to ask if there is a way of surpressing the negative numbers please. I have included a demo database of what is happening as I am not so good at explaining myself. Many thanx

[weekend00]

I could not download a ".mdb" file due to company policy. please attach a .zip file.

[Gabriel984]

many thanx for your time....have now attached zip file

[weekend00]

My mistake.

You should use
[end] - ([start]) * 24
instead of
([start] - [end]) * 24

you need a full date/time, not short time, if you have end time and start time on different day.