Formatting and Updating

[GendoPose]

Hi all, thanks for everyone's help so far!

Just a couple of quick questions now;

Firstly, I have a time elapsed field (in HH:MM) and occasionally the time elapsed will go over 24 hours, however say a job runs for 30 and a half hours, the field will just show 06:30 when really I want it to show 30:30, so is there anyway I can achieve that? This field is getting data from certain calculated fields based on a selection in a combo box.

Secondly, is there anyway to run an update on this field? The VBA code to work out hours is under AfterUpdate, and I don't want to go through every single record and have to retype in something in a field for it to update, so is there a way to update this field for all records so it works it out for me?

Thanks!

 

[CazB]

if you store a field as date/time, it won't allow you to 'go over' 24 hours... how is it calculating it? and why are you storing a calculated field, rather than just calculating it on the fly?

 

[GendoPose]

It's calculating it as (Quantity/Rate)/24 and I have to store it because we need to run a report so we can see how many hours each machine will be running for.

 

[Mihail]

This field is getting data from certain calculated fields based on a selection in a combo box.

Give us an example.

Secondly, is there anyway to run an update on this field?

So, 7 - 5 = 2 and the question is if you can modify "2" to... 3. NO. First you should modify the math

when really I want it to show 30:30, so is there anyway I can achieve that?

Yes.